How to move text from Row to Column

S

swatsp0p

Hightlight the cells in the row and copy. Select the destination cell
and Paste>Special and choose Transpose. Click OK

Does this work for you?

Bruce
 
S

soddydj

That did not work

Example:

COL.
A B C D E

AC10
AC11
BNB56
SXHD25
EU25F


WANT


A B C D E

AC10 AC11 BNB56 SXHD25 EU2
 
D

Dave Peterson

Select A1:A5
edit|copy
select a cell not in A1:A5 (b1???).
edit|paste special|Transpose

(delete column A if you want.)
 
Top