Replace text in a hyperlink based on infromation in another cell

I have an excel file that has 243 rows with excel file names in one column. I want to pull data based on that excel document but don’t want to have to link all 243 documents individually.

 

Example:

CELL A1                                                  CELL B2

Info_2019_04.xlsx              =’https://portal/sites/Library/[Info_2019_04.xlsx]TAB’!$B$6

 

Is there a way that I can create Cell B2 to have the hyperlink information but the information within the [ ] can change based on the data in Cell A1?

By: Virginia

332 thoughts on “Replace text in a hyperlink based on infromation in another cell

  1. Baixar Iptv Smart

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  2. Aplicativo De Tv Para Smart Tv

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  3. dinh cu Ireland

    Your style is so unique compared to other people I have read stuff from. Many thanks for posting when you have the opportunity, Guess I will just book mark this web site.

  4. Love

    In my country we don at get any of this kind of article. Need to search around the globe for such quality stuff. I congratulate your effort. Keep it up!

  5. dentist

    It is truly a great and useful piece of info. I am glad that you shared this helpful information with us. Please keep us informed like this. Thank you for sharing.

Comments are closed.