Excel Formula: copy data and add "0000"

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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! :)



1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month