| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
=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. . |
|
#3
|
|||
|
|||
|
=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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use a formula in place of OffsetRows? | Excel Discussion (Misc queries) | |||
| What takes the place of a space in a formula? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Inserting row but with formula carried down | Excel Worksheet Functions | |||
| Req Formula to place 1 into next columns | Excel Worksheet Functions | |||
Linear Mode
