Hi,

I have a column with formatted leading zero integer values like this:

12345678910
00123456789

and I need to insert a space in this string like this:

123456 78910
001234 56789

I tried to use this function,

=MID(F1;1;6)&" "&MID(F1;7;5)

however it interprets cells as integer values and not the cells' formatted
text values.

How can I in my formula use the cells' actual displayed formatted text
instead of the integer value?

Thanks a lot for hints on this

regards

Rod