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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Put A Space Between 2 right characters
Try this:
=LEFT(A1,LEN(A1)-2)&"_"&RIGHT(A1,2) assuming your text is in A1. Copy down as required. Hope this helps. Pete On Apr 8, 2:03*pm, carl wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Put A Space Between 2 right characters
=LEFT(A1,LEN(A1)-2) & " " & RIGHT(A1,2)
-- Gary''s Student - gsnu200777 "carl" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Put A Space Between 2 right characters
Or try this......
=REPLACE(A1,LEN(A1)-1,," ") Regards Bosco "Pete_UK" wrote: Try this: =LEFT(A1,LEN(A1)-2)&"_"&RIGHT(A1,2) assuming your text is in A1. Copy down as required. Hope this helps. Pete On Apr 8, 2:03 pm, carl wrote: 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. |
Reply |
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) |