software

Hello,

Is there a way to insert a space into a string of characters in a cell? For
example, I have quot;ABCDEFGquot; in A1, but I want B1 to read quot;ABC DEF Gquot;.

This should do it =CONCATENATE(LEFT(A1,3),quot; quot;,MID(A1,4,3),quot; quot;,RIGHT(A1,1))
--
Peter
London, UKquot;EarlyJquot; wrote:

gt; Hello,
gt;
gt; Is there a way to insert a space into a string of characters in a cell? For
gt; example, I have quot;ABCDEFGquot; in A1, but I want B1 to read quot;ABC DEF Gquot;.

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

quot;Peterquot; wrote:

gt; This should do it =CONCATENATE(LEFT(A1,3),quot; quot;,MID(A1,4,3),quot; quot;,RIGHT(A1,1))
gt; --
gt; Peter
gt; London, UK
gt;
gt;
gt; quot;EarlyJquot; wrote:
gt;
gt; gt; Hello,
gt; gt;
gt; gt; Is there a way to insert a space into a string of characters in a cell? For
gt; gt; example, I have quot;ABCDEFGquot; in A1, but I want B1 to read quot;ABC DEF Gquot;.