| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns Problem
I've pasted a bunch of names into a spreadsheet and done the text to columns
wizard to seperate them into different cells. Now the problem is that they are in cells in a single row instead of stacked on top of each other. Can someone help me?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text to Columns Problem
Highligh the cells, copy
go to the first column of the next row, paste special checkmark "transpose" "Jen711" wrote: I've pasted a bunch of names into a spreadsheet and done the text to columns wizard to seperate them into different cells. Now the problem is that they are in cells in a single row instead of stacked on top of each other. Can someone help me?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text to Columns Problem
And, just for further reference, text to columns is meant to separate the
values across a row, not down a column. Unfortunately, there is no text to rows function that I'm aware of... "Sean Timmons" wrote: Highligh the cells, copy go to the first column of the next row, paste special checkmark "transpose" "Jen711" wrote: I've pasted a bunch of names into a spreadsheet and done the text to columns wizard to seperate them into different cells. Now the problem is that they are in cells in a single row instead of stacked on top of each other. Can someone help me?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Copy from a Cell to a text box. | Excel Worksheet Functions | |||
| Numbers stored as text causes problem with VLOOKUP | Excel Worksheet Functions | |||
| Text to Columns - moves text up | Excel Discussion (Misc queries) | |||
| Text to columns will not shut off. | Excel Worksheet Functions | |||
Linear Mode
