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
 
You must log in or register to reply here.

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

Removing leading and trailing space... 2
How do I remove spaces at the beginning of cells? 3
How do I remove leading spaces the column is left justified 3
IMPORTING PC-DOS PLAIN TEXT FILES WITH LEADING SPACES 4
keeping leading 0's when formatting cells 3
Removing leading/trailing spaces 2
How keep Leading/Trailing spaces when save in Excel? 0
How can I remove a non-printing character from a cell? 2

Back
Top