I need to copy UPC codes from one spread sheet to another. The 11-digit number in the first workbook has each digit in a separate cell.
I want to copy and paste those 11 digits into a single cell in workbook two. Any advice?
Thank you in advance.
Nicholas
1) In a 12th cell, use a concatenation formula to integrate the code digits into a single string. Something like:
=A1&B1&C1&D1&E1&F1&G1&H1&I1&J1&K1
2) Copy that formula down the new column to get all the codes to appear.
3) Highlight and copy the new column of values
4) Switch to the new workbook and do a EDIT > PASTE SPECIAL > VALUES
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
You folks make me look so damn good at the office. Thank you.
Glad to improve your cred!
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks