Reputation: 663
How to remove all text after a specific character in Excel
This question relates to Excel.
I am trying to remove all text to the left of a specific character in a cell using a formula, but I keep getting an error.
I have a list of users in my website database, and I exported the email field like the following:
[email protected]
[email protected]
[email protected]
[email protected]
I want to remove everything to the left of the @ symbol so that on each persons profile, I can display @abc.com after their full name.
I tried a number of formulas and the following seems to be the one which I should be using:
RIGHT(A1,LEN(A1)-FIND("@",A1)+1)
or maybe
=MID(A1,FIND("@",A1)+2,256)
However, none of these work and Excel keeps telling me "We found a problem with this formula". Can anybody tell me what's going wrong? I am using the latest version of Excel.
Upvotes: 2
Views: 12435
Answers (1)
Reputation:
If your email address is in a1 then this will work
=MID(A1,FIND("@",A1,1),LEN(A1)-FIND("@",A1,1)+1)
Upvotes: 2
Related Questions
- How to remove text/characters from an Excel cell
- How to remove all text from right after certain characters in excel
- How can I remove all letters after a certain character in a column in Excel?
- Excel - Remove All Text Before A Character In Sequence
- Remove everything before specific character if found in Excel
- Excel - remove characters after a specific character
- How do I remove part of a string in an excel cell?
- Delete ALL text to the left of a particular character in MS excel
- Remove text before last specified special character in Excel
- Remove everything after certain string in Excel 2010