how do i unstring text in an excel cell?

[phillieberman]

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.