Formatting columns of 14 digit numbers

[sdan]

I'm trying to add spaces between digits in columns of 14 digit numbers.

Current format: 12345678901234

Desired format: 12 3 4567 8901 23 4

Can anyone tell me how to do it?

Thanks,

sdan

 

[tjharlan]

This will work assuming that the number is in cell A1


=CONCATENATE(LEFT(A1,2)," ",MID(A1,3,1)," ",MID(A1,4,4)," ",MID(A1,8,4)," ",MID(A1,12,2)," ",RIGHT(A1,1))

Hope this helps.

T.J.

 

[Oaktree]

=LEFT(A1,2)&" "&MID(A1,3,1)&" "&MID(A1,4,4)&" "&MID(A1,8,4)&" "&MID(A1,12,2)&" "&RIGHT(A1)

 

[Norie]

Try going to Format>Cells... and select Custom and enter the following:

## # #### #### ## #

 

[sdan]

Norrie / Oaktree / T.J.

Thank you all for your help.

sdan