Paste Values into Just One Cell

K

Kenichi

New Member
Joined
Sep 17, 2009
Messages
30
So I have a bunch of data but when I paste it, it gets pasted into many rows. I just want the data to be pasted into a single cell, nothing more.

I'm sure there's an easy way to do this but I just can't figure out how.

Thanks. :)
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
If you mean you have a bunch of data from copying from another app, let's say a web page, and when you paste it in excel, Excel parses it out...

Try: Select the cell, press F2, press CTRL + V
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Question
Copying and pasting a long row has issues
2 3 4
Replies
36
Views
695
Asbestos_Jen
Asbestos_Jen
J
  • Question
Pasting question
Replies
1
Views
160
NoSparks
N
S
  • Question
VBA Code to Copy Dashboard Date Data, Lookup that Date on YTD Data tab, and Paste Value?
Replies
1
Views
234
SirGruffles
S
zookeepertx
  • Solved
Pasting data - automatically does a text-to-columns. WHY?
Replies
5
Views
352
Joe4
Joe4
E
  • Question
VLOOKUP or similar to cut/paste data
Replies
3
Views
135
kvsrinivasamurthy
K

Forum statistics

Threads
1,214,944
Messages
6,122,387
Members
449,080
Latest member
Armadillos

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top