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.