Pasting /transposing from rows to columns.

I

ian.qmulus

I'm trying to copy an address from a web page and paste it to colums
in a speardsheet Excel 2000/2003.

The address is like this

A Man
21 High Street
Anytown
UK

When I paste into excel it pastes each line in to a different row.
paste special just gives the option to paste as unicode text or text.
No transpose option.

Any suggestions how to paste this address across four columns not
rows?

Thanks.

Ian
 
S

Saruman

Do the copy and Paste Special and select text.

Then copy the pasted data straight away BEFORE clicking away from the
selection.

Select a single cell somewhere and Paste Special again.

This time click the Transpose Box at the bottom right of the form and paste
the data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Splitting a cell into rows instead of columns 12
TRANSPOSE ROWS TO COLUMNS 4
Excel 2010 not allowing me to paste as formula 5
Transpose, Paste Special 2
Transposing columns to rows 3
Arrange data spanning 8 columns and 3 rows to 24 columns and 1 row 2
How to covert rows to columns or columns to rows. 11
Transpose Large Column to Row 2

Top