Microsoft Excel Numbering

[pbx2]

Is there a way to automatically, easily add numbers to cells so that i can put something that does not form a pattern but is already typed out to each cell

 

Like 1,56,76,899,5678 so that it looks like:

1

56

76

899

5678

[Guest]

Ummm, what's the relation between those numbers? Where are you getting them from?

[pbx2]

Just now, AUniqueName said:

Ummm, what's the relation between those numbers? Where are you getting them from?

I basically want to be able to paste in train serial numbers easier, Lets say i have

153301, 153304, 153307, 153315-153317, 153324, 153328, 153330-153332, 153351, 153352, 153358-153360, 153363, 153378

 

I want to drop those numbers into separate cells quicker than typing them all in or copying them one by one.

[Guest]

1 minute ago, pbx2 said:

I basically want to be able to paste in train serial numbers easier, Lets say i have

153301, 153304, 153307, 153315-153317, 153324, 153328, 153330-153332, 153351, 153352, 153358-153360, 153363, 153378

 

I want to drop those numbers into separate cells quicker than typing them all in or copying them one by one.

Do you have those in a separate file or anything? Or are you just getting them one by one from somewhere? 

[pbx2]

1 minute ago, AUniqueName said:

Do you have those in a separate file or anything? Or are you just getting them one by one from somewhere? 

 

 

Copied from Wikipedia, i want them in an excel book all in separate cells

[Guest]

2 minutes ago, pbx2 said:

 

 

Copied from Wikipedia, i want them in an excel book all in separate cells

Oh right I understand now. 

 

Paste your list into a single cell, e.g.: 

Spoiler

 

Go to the 'Data' tab, and then 'Text to Columns'

Choose 'Delimited'

Utick 'Tab' and select 'Comma'

Spoiler

 

Leave it as General or whatever and click Finish. 

 

Note that this assumes there's something you can base the separate values on, such as a comma, tab or space

 

If you then want to turn those values into a single column, select them all, right click and select copy. Then right click wherever and in the paste option choose Transpose (icon is a rotated column to row) 

[Jarno.]

Edit: nvm completely misunderstoond question 

 

 

[pbx2]

10 minutes ago, AUniqueName said:

Oh right I understand now. 

 

Paste your list into a single cell, e.g.: 

  Reveal hidden contents

 

Go to the 'Data' tab, and then 'Text to Columns'

Choose 'Delimited'

Utick 'Tab' and select 'Comma'

  Reveal hidden contents

 

Leave it as General or whatever and click Finish. 

 

Note that this assumes there's something you can base the separate values on, such as a comma, tab or space

 

If you then want to turn those values into a single column, select them all, right click and select copy. Then right click wherever and in the paste option choose Transpose (icon is a rotated column to row) 

Thanks very much