Spreadsheet/Excel Experts I need Help

my friends,

Let say I have a link list.

let say it's 50 links numbered 1 to 50.

ex:
1. link 1.com
2. link 2.com
3. link 4.com
4. link 4.com
5. link 5.com
6. link 6.com
7. link 7.com
8. link 8.com
...
...
...
50. link 50.com


So now I want to manual check each link is index or not by adding "site:" to the in-front of this link in different column.

ex: site:link1.com


How to fill this automatically for all 50 links without manually adding site: in-front of the link list? Then I can easily click on that link and open google for that to check if it's indexed or not, without typing it on google. (time saving) If anyone know kindly advice me to do this.

Thank you very much

you can use CONCATENATE() formula.
=CONCATENATE(XX1;XX2;XX3; etc.)
XX1= "site:"
XX2="link2.com"

easy 5 secs job!

coeuno said:

you can use CONCATENATE() formula.
=CONCATENATE(XX1;XX2;XX3; etc.)
XX1= "site:"
XX2="link2.com"

easy 5 secs job!

Click to expand...

I'll try this one and reply here again. Thank you very much

coeuno said:

you can use CONCATENATE() formula.
=CONCATENATE(XX1;XX2;XX3; etc.)
XX1= "site:"
XX2="link2.com"

easy 5 secs job!

Click to expand...

Thank you very much . It worked