ExcelBanter - Parsing a text string into separate cells

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Parsing a text string into separate cells (https://www.excelbanter.com/excel-worksheet-functions/145515-parsing-text-string-into-separate-cells.html)

Bobalew

Parsing a text string into separate cells

Does anyone know how to take a text string like a name (ie Mr. and Mrs. John
Q. Public, Jr.) and parse it into separate cells?

JE McGimpsey

Parsing a text string into separate cells

One way:

Data/Text to Columns...

In article ,
Bobalew wrote:

Does anyone know how to take a text string like a name (ie Mr. and Mrs. John
Q. Public, Jr.) and parse it into separate cells?

All times are GMT +1. The time now is 01:51 AM.