Separating texts separated by commas in a cell

  • Thread starter Thread starter somto
  • Start date Start date
S

somto

Please

I would like to know how to separate text separated by commas in
cell. For example; In a cell containing the text v1,v2,T1. i want t
write the texts "v1" , "v2" and "T1" in separate cells.

Thank you
 
somto

Data>Text to Columns>De-limited by comma.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Matrix operations 3
import and saving data 1
Parsing cells to reformat a multi-entry field database 2
copy cell from separate excel 1
Excel VBA - Force 4 commas into a text field on userform 7
VLookup help, or similar function help, Please! 2
List comma separated 21
Macro Box Help 1

Back
Top