Split a cell

  • Thread starter Thread starter Priscilla
  • Start date Start date
Select a cell or entire column you want to split, then
select Data - Text to Columns. Make sure you have an empty
column on the right of the column you're spliting or there
won't be any room for the data you're spliting off.
 
You can't split a single cell, but you can fake it by merging two adjacent
columns and then un-merging the row you want the "split" cells in........

Vaya con Dios,
Chuck, CABGx3
 
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

VBA Multiple Line handling with Split() 1
Split cell based on uppercase letter 2
Splitting cells in Excel 2007 1
Splitting cell contents into 2 cells 1
Starting a new line 2
cell splitting words 2
Word Removing unwanted "lines" within a MS Word 10 table 1
How to split numeric result of a formula in a cell into 2 cells? 2

Back
Top