How can I insert a vertical column break between data to create a.

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

Guest

How can I insert a vertical column break between data to create a new column?
I pasted data that has a combination of words and numbers. I want to separate
the numbers from the words so I can rank the numerical part of the data. Is
this possible?
 
Hi!

You can do this easily using the Text To Columns command
from the Data menu.

Without any sample data to go by I can't be more specific.

Biff
 

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 - retrieve data on last create named range from previous inserted named range 0
How do I remove unnecessary vertical page break? 2
Vertical Database to Horizontal? 4
How break column formatting to vary cell widths vertically? 1
Excel Concatenate with line breaks but ignore blank cells 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Breaking a tie - Excel 2003 5
text to column 1

Back
Top