Seperate Merged Cells with multiple rows?

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

Guest

I have cells with multiple phone numbers in there with different formats.
When I highlight the column and choose the text to columns option and select
the deliminted option, there is no way to seperate the information due to a
charachter sign ( a box representing the Shift+Enter function). I would like
to place each seperate phone number in a different row.
 
You mean alt + enter, if so select other and click in the other box in step
2 of text to columns,
hold down alt while typing 010 on the numpad, release alt and click finish

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 

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

Spliting a cell with multiple entries into seperate rows 1
VBA Excel partial cell compare to another cell 0
Merging multiple columns into one column (dynamically) 1
Merging Information From Two Seperate Cells 5
Count help with numbering Rows? 2
Data Lookup 3
dividing a number into hours and minutes 1
contents of cells to rows 6

Back
Top