Format text in cell to view with spaces?

Originally Posted by nkoichev

Can I format a cell with text inside to show the text with spaces between some characters?

EXM: The text in A1 is "ABCDEFG". I want to see it "AB CD EF G" or "ABC DEF G".

you can use function to do this
if your data is in A1 put in B1

=MID(A1,1,2)&" "&MID(A1,3,2)&" "&MID(A1,5,2)&" "&MID(A1,7,2)

Regards.