Getting multiple values out of one cell
Closed
jjz0512
Posts
1
Registration date
Thursday January 23, 2014
Status
Member
Last seen
January 23, 2014
-
Jan 23, 2014 at 08:07 PM
Blocked Profile - Jan 24, 2014 at 10:36 AM
Blocked Profile - Jan 24, 2014 at 10:36 AM
I trying to copy into another cell data from 1 cell that has multiple values that are seperated by blanks. Example a1 has 123 456 789.
I used the formula, =MID(a1,1,FIND(CHAR(32),a1,1)-1), and was able to find the value 123.
But how do i find the second space and value of 456?
Your help is appreciated and thank you in advance!!
I used the formula, =MID(a1,1,FIND(CHAR(32),a1,1)-1), and was able to find the value 123.
But how do i find the second space and value of 456?
Your help is appreciated and thank you in advance!!
Related:
- Getting multiple values out of one cell
- How to make multiple selections in photoshop - Guide
- Allow multiple downloads chrome - Guide
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- How to delete multiple files on mac - Guide
- Can you log into instagram on multiple devices - Instagram Forum
