I have reviewed other questions which get 'close' but don't quite address my issue.I have a range of cells like (which we will call A1,A2,A3)BobCharlieMarywithin each cell I would like to embed a hyperlink in each cell in that rangewhich would look something like: =HYPERLINK(http://www.myURL.com/user/ & A1,Bob) so that the URL effectively becomes http://www.myURL.com/user/bobThis (understandably) creates a 'circular reference'...Is there anyway around this?
Include Cell Content as Part of Hyperlink
google spreadsheets
This (understandably) creates a 'circular reference'...Is there anyway  around this?You can get circular references to work by going to File > Spreadsheet settings > Calculation > Iterative calculation in your spreadsheet and switching that to On.You can also set the number of iterations the circular references will be calculated for. For your case, you might need to set this to 1 or 2 or something like that to get the exact behavior you're looking for.