Custom format cell to insert space between letters and numbers

[ExcelNewbie2020]

Sirs,


How can I custom format cells to insert space between letters and numbers in a cell?

	RESULT
AB25CD1234	AB 25 CD 1234

thanks

 

[RoryA]

There is no custom format for that. You would have to use a separate formula cell, or code to actually alter the current cell contents.

 

[ExcelNewbie2020]

There is no custom format for that. You would have to use a separate formula cell, or code to actually alter the current cell contents.

thanks, how can it be done using a formula?..

 

[RoryA]

Something like:

=LEFT(A2,2)&" "&MID(A2,3,2)&" "&MID(A2,5,2)&" "&right(A2,4)

depending on how uniform the data is. If the sections might vary in length, it can get more complicated.