Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spacebar extras removal
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spacebar extras removal
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spacebar extras removal
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spacebar extras removal
You're welcome
"camelbreath" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spacebar to tab | Excel Discussion (Misc queries) | |||
excel 4.0 macro removal tool | Excel Discussion (Misc queries) | |||
Excel Password Removal | Excel Discussion (Misc queries) | |||
Excel and spacebar | Excel Discussion (Misc queries) | |||
hitting spacebar in excel deletes last character entered. | New Users to Excel |