Hi Ed,

You posted in the programming group so you must want a VBA solution and you
got two. Here is a formula solution you may find helpful... or not.

=IF(MID(A1,3,1)<" ",LEFT(A1,3)&" "&MID(A1,4,LEN(A1)),A1)

Copy Paste Special Values to get rid of the formulas.

Regards,
Howard

"Ed Peters" wrote in message
ups.com...
Hi,

I have a variable length data in a cell.

I need to be able to insert a blank space after the 3rd character from
the right if one does not already exist.

How would I go about doing this?

Thanks,

Ed