Exctracting comma seperated data from a single cell

  • Thread starter Thread starter guyvanzyl
  • Start date Start date
G

guyvanzyl

I want to know how to autopopulate multiple cells from comma seperated
data that is pasted into a single cell e.g. a csv file

1,2,3

Rob 1
John 2
Steve 3
 
Nel post *guyvanzyl* ha scritto:
I want to know how to autopopulate multiple cells from comma seperated
data that is pasted into a single cell e.g. a csv file

1,2,3

Rob 1
John 2
Steve 3
Click to expand...

Excel is able to open csv file, so you should have no problem, but if you
have, you have to way to solve:

1) Before opening your file, change the extension of file to .txt and open
it from Excel (menu File, Open, Files of type choose Text files, select your
file, Text Import Wizard will start), and choose Delimited at first step of
Text Import Wizard and Comma as Delimiters at step 2;
2) With your file opened, use Text to Columns (Menu Data, Text to Columns)
and choose Delimited at first step of Text to Columns Wizard and Comma as
Delimiters at step 2.


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
Thanks Franz, I will give it a go. I have used the text to columns
function but it auto populates the data across 3 columns rather than in
selected cells.
 
With your string of 1,2,3 in A1, use these formulas

In B1 =LEFT(A1,FIND(",",A1,1)-1) returns 1
In B2 =MID(A1,FIND(",",A1,1)+1,FIND(",",A1,FIND(",",A1,1))-1) returns 2
IN B3 =MID(A1,FIND(",",A1,FIND(",",A1,1)+1)+1,99) returns 3

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top