| 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 |
| 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) | |||
Threaded Mode
