Find in column A and add in column B only, following, others, file

andy

I have TEXT like this and others in a one column file (column A only). Column B is empty.
=856  40$u10.1007/b106006
=856  40$uisbn/9780306479229
=950  \\$aBehavioral Science (Springer-11640; ZDB-2-BHS)
Question

If a row in column A starts with '=856  40$u10.1007/'
then  I need to enter the following in column B of this row: '$zAccess via. Springer Link'
If a row in column A starts with '=856  40$uisbn/'
then I need to enter the following in column B of this row: '$zAccess via. Scholars Portal Link'
How could I accomplish this?
Thank you.
mandan

See if this works:

=if(isnumber(find("=856 40$u10.1007/")),"$zAccess via. Springer Link","")

Mike

=if(isnumber(find("=856 40$u10.1007/")),"$zAccess via. Springer Link","")

I copy pasted this to column B. It did not work. I may need some direction too as I never used macros / scripts in excel.

Thank you.

Well, the reason you are having trouble is because I missed something in the formula!  Sorry about that!

Try this:

=if(isnumber(find("=856 40$u10.1007/",$A1)),"$zAccess via. Springer Link","")

Where A1 assumes the formula is in Cell B1.  If you are a number of rows down, modify accordingly.

Sorry for the confusion.

FYI, this is not scirpt or macros - just plain ole' functions.  Read help for if, isnumber, and find to see how it all works.

Mike

Hi Mike,
It works! Thank you very much.
Regards,
mandan