Thread
:
change a vertical list of numbers to horizontal list from 1 cell
View Single Post
#
4
Posted to microsoft.public.excel.misc
paul
external usenet poster
Posts: 247
change a vertical list of numbers to horizontal list from 1 ce
ahh yes "in a single cell" was a good clue wasnt it!
--
paul
remove nospam for email addy!
"Pete_UK" wrote:
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 With Quote
paul
View Public Profile
Find all posts by paul