I think this will work for you:
=LEFT(A3,2) & " " & RIGHT(A3,2)


--
RyGuy


"Stephen" wrote:

"carl" wrote in message
...
Raw Formated
HPQEI HPQ EI
HPQBV HPQ BV
DDMX DD MX
EMCPE EMC PE


I am trying to convert (reformat) ColA to ColB. The right 2 characters
need
to be separated from the other characters by a space AND the left
characters
need to have a length of 3. For example, for row 3 (DDMX), I need the
formated value to be DD__MX.

Thank you in advance.

Try this:
=IF(LEN(A1)=5,LEFT(A1,3),LEFT(A1,2)&" ")&" "&RIGHT(A1,2)