Auto Format

[dan ally]

All,

I have a list of 8 and 11 character codes stored within an excel spreadsheet.

For example

DABADKKK
CHASGB2LFED

I would like format these items so that they have a space after 4 characters, 6 charatcers and 8 characters i.e

DABA DK KK
CHAS GB 2L FED

Is there a way that excel can automatically do this?

Thanks in advance.
Dan.

[arthurbr]

=if(len(e9)=8;LEFT(E9;4)&" "&MID(E9;5;2)&" "&RIGHT(E9;2);LEFT(E9;4)&" "&MID(E9;5;2)&mid(e9;7;2)&" "&" "&RIGHT(E9;3))

You might need to replace ; with , depending on your XL version

[dan ally]

Arthur,

Worked perfectly thanks for your help!

Regards,
Dan.

[arthurbr]

Welcome. Thx for the feedback !