Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel help needed

Status
Not open for further replies.

mach04

Technical User
Jun 21, 2004
237
DK
I have a row of numbers which I have copy/pasted in Excel, and I need these numbers to be places in different cell.

Imagine there are 10 numbers in the row, by copy/paste they fill in only one cell f.ex A1, but I need them to take a cell for each number that is in the row, such as A1, A2, A3, ..., A10.

Is it possible in Excel to give each of these numbers a cell for each one?
thanks in advance.
 
Excel has a feature called 'Text to Columns' which will split the text in a cell into individual columns/cells.
Select 'Text to Columns, choose 'Delimited', Next, choose the delimiter (comma it appears) uncheck any others, Next, usually you can leave the data format as general, and you can select the destination for the data, then Finish, and you should be set.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top