llawrenceg
asked on
delete all formatting after last cell character
I have a spreadsheet with 1000 email addressed imported into it. However, they do not have the underlining nor do they operate as an email. I discovered that there is extraneous formattingin the cells that prevents me from using the emails.
I would like to have some vba code that steps through each cell in the usedrange and delete all formatting after the comma ending the emal address
Is it possible using delete or truncate to get rid of the extraneous formatting on the right side of the cell? If so , please let me know how
I would like to have some vba code that steps through each cell in the usedrange and delete all formatting after the comma ending the emal address
Is it possible using delete or truncate to get rid of the extraneous formatting on the right side of the cell? If so , please let me know how
ASKER
Did not work. I've attached a mini dummy file to help. The original file has several rows of addresses but they are not "live" addresses. I have to delete the character space right after the comma and hit enter for the address to convert to a mailto: address.
I'm sending an email to hundreds and the email system requires working email addresses each separated by a comma.
So if you can show me how to code for the delete after the comma and clicking enter, I would appreciate it
email-converter.xls
I'm sending an email to hundreds and the email system requires working email addresses each separated by a comma.
So if you can show me how to code for the delete after the comma and clicking enter, I would appreciate it
email-converter.xls
Hi,
If I understand you well
Hake, John@yahoo.com, sould become Hake,John@yahoo.com,
Regards
If I understand you well
Hake, John@yahoo.com, sould become Hake,John@yahoo.com,
Sub DoitOncemore()
For Each cell In ActiveSheet.UsedRange
cell.Value = Replace(cell.Text, " ", "")
Next ' cell
End Sub
Regards
ASKER
Not quite .
So if you can show me how to code for deleting everthing after the last comma and clicking enter, I would appreciate it
I made an error on samle file
the addresses look like this
Preston.Rosemarie@yahoo.co m, Hake.John@yahoo.com, Senna.Sharon@yahoo.com,
With a period in the name and a comma between addresses.
So I need to delete everything after the last comma and then hit enter for each cell
So if you can show me how to code for deleting everthing after the last comma and clicking enter, I would appreciate it
I made an error on samle file
the addresses look like this
Preston.Rosemarie@yahoo.co
With a period in the name and a comma between addresses.
So I need to delete everything after the last comma and then hit enter for each cell
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Rgonzo1971:
I think we have it to the point I can finish it. Great learning experience for me.
Thank you
I think we have it to the point I can finish it. Great learning experience for me.
Thank you
ASKER
Great work Thanks for the lesson as well
pls try
Open in new window
Regards