You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
How do I take a number/text string such as Z945692345F and separate each character or digit into its own unique cell?
A visual illustration below. If someone can illustrate how I can do this I would really appreciate the help
MacBook Pro 14″, macOS 14.5
...and if you don't want a row of numbers at the top, you can use COLUMN() instead. If the first character is in column B then use COLUMN()-1 in place of the B$1 in Ian's formula.
Hi guyoddell,
The function MID is your friend.
Prepare your table with numbers in Header Row 1.
Formula in B2 is MID($A2,B$1,1)
Fill right and fill down.
Regards,
Ian.
separating a number into separate cells
