Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-11-2015, 10:00 AM
anickles anickles is offline Copy & Paste Issue Windows 7 64bit Copy & Paste Issue Office 2007
Novice
Copy & Paste Issue
 
Join Date: Feb 2015
Posts: 3
anickles is on a distinguished road
Default Copy & Paste Issue

I'm having some trouble copying data to multiple cells. I have three columns:



A: First Name
B: Last Name
C: Domain Name

My formula is this:

A:A & "." & B:B & E2


The formula works and I can copy and paste but only to one cell at a time.

If I try to paste to multiple cells I get the error:

Data on the clipboard is not the same size and shape as the selected area.
Reply With Quote
  #2  
Old 02-11-2015, 11:32 AM
gebobs gebobs is offline Copy & Paste Issue Windows 7 64bit Copy & Paste Issue Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

=A1 & "." & B1 & E1

Don't you need something between the last name and the domain?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy & Paste Issue Paste and Copy Quadro Excel 4 07-15-2014 05:59 AM
Copy and paste table Patrickjm Word 1 03-19-2013 03:30 PM
Copy & Paste Issue Paste Special: Copy and Paste Formatting Only? tinfanide Word 6 03-06-2013 12:21 AM
Can't copy paste irenasobolewska Office 2 10-26-2012 05:09 PM
Copy & Paste Issue Word 2007 Copy/Paste Excel issue raven26c Word 1 11-18-2011 02:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:35 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft