Wednesday, July 4, 2012

yogi_Replace [at] or Last Instance of at In A String To Make It A Valid Email Address

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #608   Jul 3, 2012

user sheldonwilkins said:
How to replace letters in a string of words on a speadsheet 
I am working on a list of email ids, but all the email ids dont have an @ but instead it looks like this email : , I want to replace the at to @ so i can easily email people by copy pasting it on my senders link.
Can some one help?

following is a solution to a little more generalized problem