| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change a vertical list of numbers to horizontal list from 1 cell
Hi
I have a vertical list of 6 digit codes and wish to copy turn them into a horizontal list in a single cell. Each code is prefixed by '. thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change a vertical list of numbers to horizontal list from 1 cell
transpose function.You select your destination range which must be the same
no of columns as you have rows,just say you have a existing range in a1 to a4 you select range d1 to g1 and in cell d1 type =transpose(A1:A4) and enter holding down ctrl and shift and then hit enter -- paul remove nospam for email addy! "caz" wrote: Hi I have a vertical list of 6 digit codes and wish to copy turn them into a horizontal list in a single cell. Each code is prefixed by '. thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change a vertical list of numbers to horizontal list from 1 cell
I think what the OP means is to put all the values into one cell (eg
B1). If that is the case, then a formula like: =A1&" "&A2&" "&A3&" "&A4 would achieve this for four used cells in column A, and will separate each number by a space. Hope this helps. Pete paul wrote: transpose function.You select your destination range which must be the same no of columns as you have rows,just say you have a existing range in a1 to a4 you select range d1 to g1 and in cell d1 type =transpose(A1:A4) and enter holding down ctrl and shift and then hit enter -- paul remove nospam for email addy! "caz" wrote: Hi I have a vertical list of 6 digit codes and wish to copy turn them into a horizontal list in a single cell. Each code is prefixed by '. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting vertical data list to horizontal data list | Excel Worksheet Functions | |||
| Display Excel list from vertical to horizontal | New Users to Excel | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Change CSV-load cell format from GENERAL to TEXT for numbers? | Excel Discussion (Misc queries) | |||
| I wish to change the last digit in a list of random numbers. To a. | Excel Worksheet Functions | |||
Hybrid Mode
