Replace part of a link with text from a cell and capitalize

[Geoff]

Hello,

I am using IMAGE formula to grab photos from a website

I would like to automatically replace part of the link with the text of a different cell and capitalize the letters.

 

Attached example file

Could you please help me out?

Thanks a lot!

[#2]

@Geoff 

=IMAGE("https://.../product/" & A98 & "/current/...", 3, 90, 90)

[#3]

Thank you!

And how to capitalize the characters of cell A98 please? Would that be possible?

[#4 · Accepted solution]

@Geoff 

That would be

=IMAGE("https://.../product/" & UPPER(A98) & "/current/...", 3, 90, 90)

[#5]

Thank you so much! @HansVogelaar