Currently my name is made up as follows

1. London, Royal Opera Hous

i would like to show the account name only as 

London (i.e. without "1." and without the second part after comma)

All this i also would like to be able to use as a hyperlink so that when i click on it, i am redirected to the relevant account

Please help, currently i only got to 

Data TypeFormula  
LEFT(Account.Name, FIND( ",", Account.Name ) -1 )

which eliminates the second part however, i cannot remove the "1." and also cannot make it work as a link

MANY thanks

Currently my name is made up as follows

1. London, Royal Opera Hous

i would like to show the account name only as 

London (i.e. without "1." and without the second part after comma)

All this i also would like to be able to use as a hyperlink so that when i click on it, i am redirected to the relevant account

Please help, currently i only got to 

Data TypeFormula  
LEFT(Account.Name, FIND( ",", Account.Name ) -1 )

which eliminates the second part however, i cannot remove the "1." and also cannot make it work as a link

MANY thanks