Spacebar extras removal

C

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). Ther
are two columns on the sheet only col a has the problem. I went to th
TRIM function in the help files and of course that only exacerbate
confusion among non-excel wonks. Any and all help is appreciated.
Thanks,
Jo
 
T

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" <[email protected]>
wrote in message
news:[email protected]...
 
Top