Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
63
Views
Topic starter
Existing Formula : HYPERLINK("F:Study MaterialOrder2017" & A3 & ".docx",A3)
Looking for : syntax as : HYPERLINK("F:Study Material+C32017" & A3 & ".docx",A3)
Now in above the folder name i.e. "Order" to be taken from cell "C3" since there are different folder whose name is appear in "C" column, so instead of typing the folder name, is it easy if it takes the name from the cell from "C" column...
Posted : 14/03/2019 5:27 am
Try
=HYPERLINK("F:Study Material"&C3&"2017" & A3 & ".docx",A3)
Posted : 14/03/2019 7:24 am