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