Removing Leading Spaces

[jlbecker67]

I have some cells that have a leading space in them and I want to remove the space. How do I accomplish this without searching all the cells?
Thanks,

Jerry

 

[Mark W.]

Select 'em and choose the Data | Text to Columns... menu command.

 

[BobUmlas]

Edit/Replace; replace " " (without quotes) with "" (without quotes)
Bob Umlas
Excel MVP

On 2002-03-28 14:49, jlbecker67 wrote:
I have some cells that have a leading space in them and I want to remove the space. How do I accomplish this without searching all the cells?
Thanks,

Jerry

 

[Mark W.]

On 2002-03-28 15:06, Bob Umlas wrote:
Edit/Replace; replace " " (without quotes) with "" (without quotes)
Bob Umlas
Excel MVP

On 2002-03-28 14:49, jlbecker67 wrote:
I have some cells that have a leading space in them and I want to remove the space. How do I accomplish this without searching all the cells?
Thanks,

Jerry

...But be careful... because this will change " junk mail" into "junkmail".
This message was edited by Mark W. on 2002-03-28 15:11
This message was edited by Mark W. on 2002-03-28 15:12

 

[Dave Hawley]

Hi

Text to Columns is probably the best solution. But the the TRIM function is good for this also, eg

=TRIM(A1)