Rick wrote:
But entering "Some text http://www.a.com more text" does not activate
the embedded hyperlink. Can this be done (without scripting if
possible)?


No.

You could enter a formula
=HYPERLINK("http://www.a.com","Some text http://www.a.com more text")

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup