ExcelBanter - how do i unstring text in an excel cell?

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

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

- - how do i unstring text in an excel cell? (https://www.excelbanter.com/excel-worksheet-functions/49099-how-do-i-unstring-text-excel-cell.html)

phillieberman

how do i unstring text in an excel cell?

a cell contains "123 a b". i want to unstring it into three cells in the
same row.

Gary''s Student

There is an Excel feature called Text to columns that does exactly what you
want.

1. select the data
2. pull-down Data Text to Columns... and let the wizard guide you.

--
Gary''s Student

"phillieberman" wrote:

a cell contains "123 a b". i want to unstring it into three cells in the
same row.

All times are GMT +1. The time now is 02:05 PM.