Getting multiple values out of one cell [Closed]

Question

Getting multiple values out of one cell [Closed]

Report

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

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!!

Getting multiple values out of one cell
Checkboxes for multiple values in a single cell in excel - How-To - Excel
Is there a way to call out multiple values in single cell? ✓ - Forum - Excel
Excel cell contains multiple values ✓ - Forum - Excel
Excel vba find multiple values in range - How-To - Excel
Conditional formatting with multiple rules and blank text cells ✓ - Forum - Excel

1 reply

Ask a question

Blocked Profile · Answer 1 · 2014-01-24T10:36:31-0500

Answer 1 / 1

Blocked Profile
Jan 24, 2014 at 10:36 AM

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

Example here:

Getting multiple values out of one cell [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!