Format with spaces in between with specific conditions

Hi!

Thank you for all the support.

I have a column : Customer Number

Customer Number: we have 2 types of customer numbers (12 or 13 alphanumeric)

eg: 446828442414 (12 alphanumeric) or 8144144141442 (13 alphanumeric)

and need them formatted according to number of digits

If 12 alphanumeric: 00<3space>0<3space>00<3space>00<3space>00<3space>000
i.e. : 44 6 82 84 42 414

or if 13 alphanumeric: 000<3space>000<3space>00<6space>00<3space>0<3space>00
i.e.: 814 414 41 41 4 42

suggestion: IF (No. of characters = 12) use 12 alphanumeric space format

or

IF (No. of characters = 13) use 13 alphanumeric space format


Appreciate your valuable time and effort

You can use this in B2:

Formula:

=IF(LEN(A2)=12,TEXT(A2,"00   0   00   00   00   000"),IF(LEN(A2)=13,TEXT(A2,"000   000   00      00   0   00"),""))

then copy down.

Hope this helps.

Pete

EDIT: Almost snap, Martin.