Insert Function?
 

Hello,

Is there a way to insert a space into a string of characters in a cell? For
example, I have "ABCDEFG" in A1, but I want B1 to read "ABC DEF G".

Insert Function?
 

This should do it =CONCATENATE(LEFT(A1,3)," ",MID(A1,4,3)," ",RIGHT(A1,1))
--
Peter
London, UK


"EarlyJ" wrote:

Hello,

Is there a way to insert a space into a string of characters in a cell? For
example, I have "ABCDEFG" in A1, but I want B1 to read "ABC DEF G".

Insert Function?
 

Thank you Peter. I thought CONCATENATE only worked with data in separate
cells. This is my first time on this site and I'm really looking forward to
reading all of the post and learning a lot. Thanks again.

John
Dallas, TX

"Peter" wrote:

This should do it =CONCATENATE(LEFT(A1,3)," ",MID(A1,4,3)," ",RIGHT(A1,1))
--
Peter
London, UK


"EarlyJ" wrote:

Hello,

Is there a way to insert a space into a string of characters in a cell? For
example, I have "ABCDEFG" in A1, but I want B1 to read "ABC DEF G".