Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to eliminate empty spaces ?
Dear Sir,
I have some text in column A with spaces (one or more spaces) and some without. I would like to make them all uniform without any spaces. A B 1 ML 12 ML12 2 ML14 ML14 3 KL 15 KL15 4 HG 1234 HG1234 5 BV412 BV412 6 BG 54 BG54 7 BC 2247 BC2247 8 LP4416 LP4416 May I know what formula must I input at cell B1 and copy downward to get the straight answer ? I try using =SUBSTITUTE(A1,-,) but I get back the same thing. Please help. Thanks Low -- A36B58K641 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to eliminate empty spaces ?
get rid of the dash
=SUBSTITUTE(A1, ,) if this does not work, there is a chance it is something other that a simple space such as a non breaking space you could copy column A to column B select column B in one of the phrases which did not work copy the space got to edit find replace paste the space into find and leave the replace empty select repace all "Mr. Low" wrote: Dear Sir, I have some text in column A with spaces (one or more spaces) and some without. I would like to make them all uniform without any spaces. A B 1 ML 12 ML12 2 ML14 ML14 3 KL 15 KL15 4 HG 1234 HG1234 5 BV412 BV412 6 BG 54 BG54 7 BC 2247 BC2247 8 LP4416 LP4416 May I know what formula must I input at cell B1 and copy downward to get the straight answer ? I try using =SUBSTITUTE(A1,-,) but I get back the same thing. Please help. Thanks Low -- A36B58K641 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : How to eliminate the time value after the date ? | Excel Discussion (Misc queries) | |||
Excel 2002: How to eliminate space within a cell and count items? | Excel Discussion (Misc queries) | |||
How to eliminate empty rows in Excel 2002 worksheet ? | Excel Discussion (Misc queries) | |||
How do I eliminate spaces/characters from the beginning of a cell | Excel Worksheet Functions | |||
macro to eliminate spaces between words | Excel Discussion (Misc queries) |