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)
Bob
Charlie
Mary
within each cell I would like to embed a hyperlink in each cell in that range which would look something like: =HYPERLINK("http://www.myURL.com/user/" & A1,"Bob") so that the URL effectively becomes http://www.myURL.com/user/bob
This (understandably) creates a 'circular reference'...Is there anyway around this?