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. |
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 |