Excel Formula: copy data and add "0000"

Closed
TLB - Jun 12, 2012 at 02:48 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 15, 2012 at 11:02 PM
Hello,

how do I copy data from worksheet 1 into worksheet 2 (i know how to do this part), AND
1) delete the 4 digits at the end (i know how to do this part), AND (here's what I don't know....)
2) replace those 4 digits with 0000

ALSO
how do I
1) look up data from worksheet 1, and
2) find the matching data on a worksheet 2, then
3) copy data in a different column from worksheet 2 into a blank column on worksheet 1

THANK YOU VERY MUCH FOR YOUR HELP, I REALLY APPRECIATE IT! :)



Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jun 15, 2012 at 11:02 PM
for adding leading 0000 you can use

="0000"&A!
something like this

reg lookup from sheet 1
post small extract of data sheets(sheet1 and sheet2) and also tell whether you are comfortable with formula or macro . you can either copy the text or upload your file to some other page like speedyshare.com
1