Getting multiple values out of one cell [Closed]

Report
Posts
1
Registration date
Thursday January 23, 2014
Status
Member
Last seen
January 23, 2014
-
 Blocked Profile -
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!!

1 reply


Hello,
Try this, use the built in function f Text to Columns.

Example here:

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!