| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Put A Space Between 2 right characters
I have some symbols that look like this
ABC ABCD ABCDE I need a formula that can make this conversion: A_BC (1 spaces between A and BC) AB_CD (1 space between AB and CD) ABC_DE (1 space between ABC and DE) So I always need the 2 right most characters separated by a space from the other characters. I hope I explained this ok. Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Characters with space in a cell | Excel Discussion (Misc queries) | |||
| How do I display white space characters in excel? | Excel Discussion (Misc queries) | |||
| Clean non printable characters and replace with space | Excel Worksheet Functions | |||
| cHARACTERS BEFORE THE SPACE | Excel Worksheet Functions | |||
| Remove varying amounts of space characters | Excel Discussion (Misc queries) | |||
Threaded Mode
