Somebody please help???

[thenos09]

My question is very simple. Im not very good in excel

I would just like to know how to format a cell to make a space every 2 characters

ie. cell A1 = 1234567890

I want to the cell to display 12 34 56 78 90

the data in cell A1 will vary but I always want a space after every 2nd character

 

[Peter_SSs]

Duplicate to http://www.mrexcel.com/forum/showthread.php?t=569416

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per the Posting Rules (especially points 21-23).

Any bumps, clarifications, or follow-ups should be posted back to the linked thread.