Hi Experts,
I want to prefix and suffix fixed value. E.g. I copy paste 123 or ABC to a cell and it should show file://ImageFolder/123.pdf or file://ImageFolder/ABC.pdf
Prefix: file://ImageFolder/
Suffix: .pdf
Value: 123 and ABC
Expected result: file://ImageFolder/123.pdf
file://ImageFolder/ABC.pdf
Any help please?
Senthil
Bookmarks