How do I split a code with space in Numbers?
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
Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
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?