software

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: www.excelforum.com/member.php...oamp;userid=32594
View this thread: www.excelforum.com/showthread...hreadid=523966I think the easiest way would be to select Column A and then:

Edit | Replace ... | Find what: quot; quot; (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

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

Thanks Trevor! --
camelbreath
------------------------------------------------------------------------
camelbreath's Profile: www.excelforum.com/member.php...oamp;userid=32594
View this thread: www.excelforum.com/showthread...hreadid=523966You're welcomequot;camelbreathquot; gt;
wrote in message
...
gt;
gt; Thanks Trevor!
gt;
gt;
gt; --
gt; camelbreath
gt; ------------------------------------------------------------------------
gt; camelbreath's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32594
gt; View this thread: www.excelforum.com/showthread...hreadid=523966
gt;