Thread: Text to colums
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Text to colums

Select and copy the horiz range. Then just right-click elsewhere on say, the
top cell of an empty col paste special transpose
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jen711" wrote:
I cut and pasted 80+ names onto an excel spreadsheet, but they all went into
a single cell. I was able to seperate all of the names into cells, but now
there 80+ columns. I would would like all of the names in one column. Does
that make sense?