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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Sort by date Sort by votes
G

GTO

MrExcel MVP
Joined
Dec 9, 2008
Messages
6,156
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

A
  • Question
Macro Buttons to Copy Non-Blank Row(s) In & Out of Excel
Replies
1
Views
167
abuahad
A
Engineer Joe
  • Question
Dynamically Created Userform
Replies
1
Views
324
Herakles
H
J
  • Question
VBA to allow numbers only of copy/pasted data while keeping destination cell formatting
Replies
1
Views
445
hajiali
H
R
  • Question
Pasting concatenated data in another worksheet whilst ignoring blanks
Replies
0
Views
64
rmcc
R
K
  • Question
Copy and paste values from one workbook to another
Replies
0
Views
234
Kamil M
K

Forum statistics

Threads
1,195,991
Messages
6,012,731
Members
441,724
Latest member
Aalbid

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
Top