Quick MS Excel 2007...
 

Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop

[Closed] Quick MS Excel 2007 question

2 Posts
3 Users
0 Reactions
40 Views
Posts: 0
Free Member
Topic starter
 

If I have a single cell with half a dozen phone numbers within it - how can I stack them in individual cells in a column?

Cheers as always


 
Posted : 09/12/2009 1:20 pm
Posts: 36
Free Member
 

Select cell
Data>Text to columns
select "delimited"
select your delimiter (maybe a space?)
press finish
copy resultant series of cells
edit>paste special, transpose, OK


 
Posted : 09/12/2009 1:23 pm
Posts: 0
Full Member
 

Cut and paste...

If it were more than 6 you could copy to notepad and import it into excel using spaces or ; etc to delimit the columns/rows (you may have to transpose...)


 
Posted : 09/12/2009 1:24 pm