ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I insert a vertical column break between data to create a. (https://www.excelbanter.com/excel-worksheet-functions/6934-how-can-i-insert-vertical-column-break-between-data-create.html)

Mark Wisdom

How can I insert a vertical column break between data to create a.
 
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?

Biff

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

-----Original Message-----
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?
.



All times are GMT +1. The time now is 03:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com