LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
 
Posts: n/a
Default how do I paste an excel column into one cell...tia sal

Greetings All,

I have a column of about 30 values. I would like to paste all these values into one cell.

I tried Edit -Paste Special and choose "value" and "transpose" but it paste each value into it's on cell.
I would like to paste all these values into one cell.

TIA
sal


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
In excel - how to total column if am not sure of the last cell PFHMoney New Users to Excel 4 May 27th 05 01:27 PM
How do I reference every "n" cell in a column in Excel? Alma Excel Worksheet Functions 2 March 22nd 05 06:19 PM
In MS Excel, how do I fill in a column with the same cell from se. krempin Excel Worksheet Functions 2 February 9th 05 08:43 PM
excel - numbers as text Thuferhawat New Users to Excel 12 January 24th 05 09:29 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM


All times are GMT +1. The time now is 05:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"