Splitting a cell after 5 characters

I have a UTR in cell A1 in the format 1234512345.  My OCD makes me need to make that 12345 12345 (I'm updating the database to filling gaps and the existing entries are in this format).

I can see how to split to cells based on there being a tab/comma/space (then I would concatenate), but I can't see how to do it by character.

So how would I make 1234512345 into 12345 12345?

Comments
There are 8 comments. Login or register to view them.

Use string handling

ShirleyM |
ShirleyM's picture

Thanks

Constantly Confused |
Constantly Confused's picture

Er...

George Attazder |
George Attazder's picture

Concatenate works

ShirleyM |
ShirleyM's picture

Why not use a Custom number format of

ACDWebb |
ACDWebb's picture

Or...

George Attazder |
George Attazder's picture

Why the hell...

Constantly Confused |
Constantly Confused's picture

Hmmm ...

Old Greying Accountant |
Old Greying Accountant's picture