Spacebar extras removal

[camelbreath]

Excel is ancillary to what I do, so I know only enough to be dangerous. I have a column of first names imported from someone else's text file. There is an extra space in front of every first name (col. a). There are two columns on the sheet only col a has the problem. I went to the TRIM function in the help files and of course that only exacerbates confusion among non-excel wonks. Any and all help is appreciated.
Thanks,
Joe

[Trevor Shuttleworth]

I think the easiest way would be to select Column A and then:

Edit | Replace ... | Find what: " " (no quotes) | Replace with: (nothing) |
Replace All

That will replace every space in column A with nothing

Assuming there is only one name in the cell, this should do the trick

Regards

Trevor


"camelbreath" <camelbreath.24w2by_1142724601.3812@excelforum-nospam.com>
wrote in message
news:camelbreath.24w2by_1142724601.3812@excelforum-nospam.com...
>
> Excel is ancillary to what I do, so I know only enough to be dangerous.
> I have a column of first names imported from someone else's text file.
> There is an extra space in front of every first name (col. a). There
> are two columns on the sheet only col a has the problem. I went to the
> TRIM function in the help files and of course that only exacerbates
> confusion among non-excel wonks. Any and all help is appreciated.
> Thanks,
> Joe
>
>
> --
> camelbreath
> ------------------------------------------------------------------------
> camelbreath's Profile:
> http://www.excelforum.com/member.php...o&userid=32594
> View this thread: http://www.excelforum.com/showthread...hreadid=523966
>

[camelbreath]

Thanks Trevor!

[Trevor Shuttleworth]

You're welcome


"camelbreath" <camelbreath.24w46o_1142727001.8583@excelforum-nospam.com>
wrote in message
news:camelbreath.24w46o_1142727001.8583@excelforum-nospam.com...
>
> Thanks Trevor!
>
>
> --
> camelbreath
> ------------------------------------------------------------------------
> camelbreath's Profile:
> http://www.excelforum.com/member.php...o&userid=32594
> View this thread: http://www.excelforum.com/showthread...hreadid=523966
>