Splitting a cell after 5 characters

Posted by Constantly Confused PM | on Fri, 22/02/2013 - 15:11 455 8 comments | report

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 | Fri, 22/02/2013 - 15:15

Thanks

Constantly Confused | Fri, 22/02/2013 - 15:16

Er...

George Attazder | Fri, 22/02/2013 - 15:19

Concatenate works

ShirleyM | Fri, 22/02/2013 - 15:20

Why not use a Custom number format of

ACDWebb | Fri, 22/02/2013 - 15:27

Or...

George Attazder | Fri, 22/02/2013 - 15:28

Why the hell...

Constantly Confused | Fri, 22/02/2013 - 15:29

Hmmm ...

Old Greying Accountant | Fri, 22/02/2013 - 15:32