Removing a leading space from cells in a column range

D

Danny

Can anyone provide me a simple macro or way to remove a
leading space from a group of cells in a column? The
column contains cells with numbers, but with the leading
space Excel treats the value as text.

Thanks for your anticipated help,

Danny
 
A

Andy Brown

Danny,

Try selecting the range, then Replace (CTRL+H). Click in the Find What box
and hit the spacebar ; then click Replace All.

Rgds,
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Identical words 0
Copy addition formula of non-consecutive horizontal cells 2
Removing leading and trailing space... 2
How do I remove leading spaces the column is left justified 3
Excel does not accept text format! 0
IMPORTING PC-DOS PLAIN TEXT FILES WITH LEADING SPACES 4
keeping leading 0's when formatting cells 3
Only first of multiple If's returns results 4

Top