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?