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.

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.

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.

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.