Forum Discussion
Replace part of a link with text from a cell and capitalize
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.   At...
=IMAGE("https://.../product/" & A98 & "/current/...", 3, 90, 90)
- Thank you!
And how to capitalize the characters of cell A98 please? Would that be possible?Thank you so much! HansVogelaar
