Removing a leading space from cells in a column range

  • Thread starter Thread starter Danny
  • Start date Start date
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
 
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
 
Back
Top