microsoft public excel newusers tips

  • Thread starter Thread starter snack
  • Start date Start date
S

snack

dear friends,
Someone sent me a spreadsheet with a column for email addresses.
Only
some of the addresses are clickable links and I thought I'd do
everyone
a service and fix the cells that aren't formatted properly and sent
the
spreadsheet back out again. (It's a team list for one of my kids'
sports
teams.)

But, when I go into format, I see lots of things like text, number,
currency, special - but no email. How does one do this?
www.rangefindecamera50webs.com
 
Right click and choose "Hyperlink" then email. You might have success
converting them in one go by Replacing @ with @.
 
Back
Top