Hi All, I have codes with two numbers and one character in a cell. How do I add space between them in the same cell using a function?
iPhone 11
I got it in the meantime.
LEFT(G1,2)&" "&RIGHT(G1,16)
Thank you.
Good catch Szimi!
Upvote for you and keep posting in Apple Support Communities.
Regards,
Ian.
Thank you. It should work but couldn’t figure it out how to adjust the formula to my case. The code looks like this: 30U 650000 5761000 where the 30 should be separated from the letter ‘U’. I need a space between 30 and U. Thanks. 🙏🏼
Hi Szimi,
Try this:
LEFT(B2)&" "&MID(B2,2,1)&" "&RIGHT(B2)
Regards,
Ian.
How do I split a code with space in Numbers?
