I am trying to use an Excel spreadsheet to create a cell with a
hyperlink to maps.google.com using latitude and longitude from other
cells. I have a formula that I am using which creates the correct
address in the cell which opens the website when I cut and past into a
browser address window. But the cell will not work directly as a
hyperlink. An example of the web address I am using is
"http://maps.google.com/maps?q=35 14.6-79 33.4"

Does this answer your question?

http://exceltips.vitalnews.com/Pages/T0463_Dynamic_Hyperlinks_in_Excel.html

You probably need to escape (URL-encode) the spaces. There should be
%20 used instead of the spaces. For your given example URL, try making
the output:

http://maps.google.com/maps?q=35%2014.6-79%2033.4

instead.

In Excel 2002 at least for me, the hyperlink function didn't escape the spaces.

I was able to get it to work with the formula below...
=IF(ISBLANK(F6)," ",HYPERLINK("http://maps.google.com/maps?q="&F6&",
"&G6&" , NC (Spotter Location) &spn=0.3,0.3&safe=active 
target=_blank","Map it With Google"))

I use a logical check (to see if the cell is blank) and then use the
hyperlink function.

Thanks for the help.