Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Ayden Smith   on Sep 30 In MS Office Category.

Need to trim leading spaces from cells


  
Question Answered By: Keith Marshall   on Sep 30

Could you be missing out a step?

1. Copy the formula to all the cells  you need on your new sheet

2. Re-select the whole area and copy

3. Then go for paste special - values. I would tend to do this from A1 rather
than keeping the whole area highlighted - this way I think you should show paste
special on the edit menu.

Share: 

 

This Question has 4 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Need to trim leading spaces from cells Or get search suggestion and latest updates.


Tagged: