Thanks for all your help, Leon, Paul and Rick! All three of these formulas
work great!
--
Jennifer


"Rick Rothstein (MVP - VB)" wrote:

I'm under the impression that for those type of postal codes, the number of
characters in front of the space can vary, but the number of characters
after it will always be 3. If that is correct, then use this formula...

=REPLACE(A1,LEN(A1)-2,0," ")

Of course, you can use the above formula if your postal codes are always 6
characters long; but, if that is the case, you can use this shorter
variation...

=REPLACE(A1,4,0," ")

Rick


"Jennifer" wrote in message
...
I am using Microsoft Excel 2003 and I was wondering if there is a formula
that will add a space in the middle of text. For example I have a column
of
postal codes that look like this N6C1V9 and I would like them to look like
this N6C 1V9 instead.
--
Jennifer