Help with Excel!!

[Sarah-Ink Promotions]

Im using Excel 2007, Ive been sent a spreadsheet with email addresses in it but where they normally go as links that you can just click on this one has a little ' before each one which stops it from doing that - Ive changed a few of them manually and tried a find and replace (it didnt find them) but it will take forever to keep doing it like that - anyone know how to do it in a really quick clever way??

Thanks!

[HuggyBear]

Hiya,

if you wanna mail me a copy of the spreadsheet I will create a little app to do it for you

my e-mail address is srigby (at) shaunrigby.co.uk

[whistle ink]

Wouldn'd Find & Replace work?

[Sarah-Ink Promotions]

Wouldn'd Find & Replace work?

no, it doesnt pick it up for some reason - I think its some kind of formatting thing as opposed to the person having actually typed them all in

[whistle ink]

oh! send it over if you want I can have quick bash at it now.

http://www.eggheadcafe.com/software/...-hidden-a.aspx

[spreadsheetsdir]

Try =HYPERLINK("mailto:"&cell) in a new column to turn it to a clickable link. If the ' is still causing a problem Text to Columns might get rid of it for you.

[Sarah-Ink Promotions]

Try =HYPERLINK("mailto:"&cell) in a new column to turn it to a clickable link. If the ' is still causing a problem Text to Columns might get rid of it for you.

Worked a treat! thanks very much