Previous Topic Next Topic

Getting multiple values out of one cell

Closed
jjz0512 Posts 1 Registration date Thursday 23 January 2014 Status Member Last seen 23 January 2014 - 23 Jan 2014 à 20:07
 Blocked Profile - 24 Jan 2014 à 10:36
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 response

Réponse 1 / 1
Blocked Profile
24 Jan 2014 à 10:36
Hello,
Try this, use the built in function f Text to Columns.

Example here:

Similar discussions

Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses