ExcelBanter - Inserting a Space in The Same Place Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Inserting a Space in The Same Place Formula (https://www.excelbanter.com/excel-worksheet-functions/16140-inserting-space-same-place-formula.html)

carl

Inserting a Space in The Same Place Formula

I have a column of data that comes in like so :

ABCAA
EFGDD
HIJSS

I would like a formula in COLB that will but a space in between the 3rd and
4th characters.

ABC AA
EFG DD
HIJ SS

I've been using the text to columns function but was hoping that a folrmula
could do they same thing.

Thank you in advance.

Jason Morin

=REPLACE(A1,4,," ")

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a column of data that comes in like so :

ABCAA
EFGDD
HIJSS

I would like a formula in COLB that will but a space in
between the 3rd and
4th characters.

ABC AA
EFG DD
HIJ SS

I've been using the text to columns function but was
hoping that a folrmula
could do they same thing.

Thank you in advance.

.

Myrna Larson

=LEFT(A1,3)&" "&MID(A1,4,2)

On Fri, 4 Mar 2005 10:25:05 -0800, "carl"
wrote:

I have a column of data that comes in like so :

ABCAA
EFGDD
HIJSS

I would like a formula in COLB that will but a space in between the 3rd and
4th characters.

ABC AA
EFG DD
HIJ SS

I've been using the text to columns function but was hoping that a folrmula
could do they same thing.

Thank you in advance.

All times are GMT +1. The time now is 07:32 AM.