I have a list of e-mail addresses however before I can use it I need to correct entries that are invalid
EG they contain an invalid character, or begin or end with an invalid character
Anyone know a quick and easy way of doing this
Right now I am filtering through whatever it is I know to be invalid (eg contains a bracket) and then correcting
Thanks
Vidhur
please post a sample workbook with atleast 10-20 rows worth of data including possibilities and expected answers.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
from what i gather you just want to get rid of the brackets?
highlight column
press CTRL+H
find what = (
replace what = leave blank
repeat with find what = )
Formula method
in B1 have
Formula:
=SUBSTITUTE(A1,"(","")
then in C1 have
Formula:=SUBSTITUTE(B1,")","")
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Please see attached. Column A contains a list of e-mail addresses. The first 17 are invalid. I need to find a way to identify invalid e-mail address as done in column C and remove them from the list as done in column B
It's not just brackets, there are a number of reasons why the e-mail address would be invalid
The sample data (not real e-mail addresses) gives a good illustration of the problems I am trying to overcome
ok that is a mix bunched of error issues
try this UDF - user defined function
http://www.vbaexpress.com/kb/getarticle.php?kb_id=281
not my code but tested with your sample data and it works perfectly
OMG that is amazing
Thank you so much, you have saved me a lot of time
not a problem
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks