ExcelBanter - How do I de-concatenate items separated by commas!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I de-concatenate items separated by commas! (https://www.excelbanter.com/excel-discussion-misc-queries/213680-how-do-i-de-concatenate-items-separated-commas.html)

Taneli Hanhivaara

How do I de-concatenate items separated by commas!

How would I take a list of items separated by commas in a field and make each
item its own field (column or row)?

Mike H

How do I de-concatenate items separated by commas!

Hi,

data|Text to Columns

Follow the wizard and use a comma delimeter

Mike

"Taneli Hanhivaara" wrote:

How would I take a list of items separated by commas in a field and make each
item its own field (column or row)?

Max

How do I de-concatenate items separated by commas!

Try Data Text to Columns, delimited comma
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"Taneli Hanhivaara" wrote:
How would I take a list of items separated by commas in a field and make each
item its own field (column or row)?

All times are GMT +1. The time now is 11:58 PM.