| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to add blank spaces to text and numbers
Dear Sir,
May I know how to add 3 empty spaces in front and behind text and numbers ? What formula must I use at cell B1 and C1? A B c 1 PTY _ _ _PTY PTY_ _ _ 2 5412 _ _ _5412 5412 _ _ _ 3 JH65 4 Thanks Low -- A36B58K641 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: How to eliminate empty spaces ? | Excel Discussion (Misc queries) | |||
| Excel 2002 : How to remove trailing spaces ? | Excel Discussion (Misc queries) | |||
| Error Message; TA Numbers To Text in Excel 2002 | Excel Discussion (Misc queries) | |||
| Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
| How do I convert numbers stored as text with spaces to numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
