ExcelBanter - some email addresses aren't blue keyed in Excel, why?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - some email addresses aren't blue keyed in Excel, why? (https://www.excelbanter.com/excel-discussion-misc-queries/67324-some-email-addresses-arent-blue-keyed-excel-why.html)

Artist999

some email addresses aren't blue keyed in Excel, why?

I keyed 600 emails in an Excel spreadsheet and some of them are underlined
and are blue and you can send an email from Excel. However, some of
them(randomly) remain black and you can't email from Excel. Why?

Ron de Bruin

some email addresses aren't blue keyed in Excel, why?

Hi Artist999

Maybe there is a apostrophe before it or a space

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Artist999" wrote in message ...
I keyed 600 emails in an Excel spreadsheet and some of them are underlined
and are blue and you can send an email from Excel. However, some of
them(randomly) remain black and you can't email from Excel. Why?

All times are GMT +1. The time now is 01:22 AM.