Splitting cells

  • Thread starter Thread starter Guest
  • Start date Start date
You can "split" contents using data>text to columns


--


Regards,


Peo Sjoblom



"Splitting one cell into multiple cells" <Splitting one cell into multiple
(e-mail address removed)> wrote in message
news:[email protected]...
 
Select the column of data and then click DATA in the menu, select TEXT TO
COLUMNS.

You'll want to make sure that there are enough blank columns to the right of
the source data to accommodate the parsed data.
 
Is there a way in Excel to split a cell into multiple cells?
Click to expand...

Yes there is.

The applicable method depends on details you have not chosen to provide,
however.
--ron
 

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

Split cell based on uppercase letter 2
Starting a new line 2
Cells 6
VBA Multiple Line handling with Split() 1
Reverse Concatenation (Splitting Single Cell Data into Multiple Ce 5
Is there any way to split contents of a cell into more cells. 2
HELP! Split cell contents to new rows 7
Split cell help! 4

Back
Top