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?
Related resources
Replies (8)
Please login or register to join the discussion.
Use string handling
String handling (left & right) and concatenation will do the job.
PS. Sorry. Meeting due so haven't time to work out the formula.
Thanks
String handling (left & right) and concatenation will do the job.
PS. Sorry. Meeting due so haven't time to work out the formula.
Cunning! I wasn't aware of Left and Right as functions, thanks.
Oddly a search in Google for 'String Hand' suggests 'String Handcuffs' as the best suggestion. Worrying...
Why the hell...
00000 00000
Why the hell didn't I just think of that! I blame Friday...
And I must admit I do like George's version, but Left/Right/Concatenate did it fine.
Hmmm ...
00000 00000
... works for me, but have learnt a new word, even if it does make me think of what a dyslexic has to do to read a book!