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

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
(E-Mail Removed)
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

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
> (E-Mail Removed)
> 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

ahh yes "in a single cell" was a good clue wasnt it!
--
paul
(E-Mail Removed)
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
> > (E-Mail Removed)
> > 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
>
>