how do i unstring text in an excel cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

a cell contains "123 a b". i want to unstring it into three cells in the
same row.
 
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.
 
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

Unstring in excel 4
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Excel Typed text appears in wrong cell 0
Red cell for negative numbers in Excel 1
VLOOK with Index - How to get results across instead of down? 3
using the =page! feature to transpose a row to column 0
Search Formual Error 4
Comparison of columns using Conditional Formatting 3

Back
Top