LinkBack URL
About LinkBacks
Hi,
I have exported my users email address from my site in an excel file, but at the end of each email address there is a quotation mark. Each email address is in a separate cell. How can I remove the quotation marks?
excel.jpg
Hi,
I have exported my users email address from my site in an excel file, but at the end of each email address there is a quotation mark. Each email address is in a separate cell. How can I remove the quotation marks?
excel.jpg
You have several options. If you want to do this without any formulas, you can highlight column A > Find & Select > Replace
Find what: "
Replace with: leave blank
If you want to use a formula, in B1:
=LEFT(A1,LEN(A1)-1)
I tried both, none of the works.
Interesting...
If you upload an Excel workbook with the data from the screenshot in it, I will put the formula in and see what's going on.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Try this
in B1
Formula:
Please Login or Register to view this content.
v A B 1 [email protected]" [email protected]
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Try using Text to Column.
Select your column. Go to data ribbon tool, click on Text to Columns.
Choose Delimited. Select Other for delimited and use " as delimiter. That should strip the trailing quote.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Try this one -
=SUBSTITUTE(A1,RIGHT(A1,1),"")
To attach worksheet Go advanced -> Manage attachments -> Choose file -> Upload
Don't forget to Mention your desired result in the sheet..
There should be sample data only, a lot of data creates confusion.
Thanks & Regards
Shivya
http://excelvbatipsforbeginners.blogspot.in/
If right character is replaced by any other digit, does your formula will work?Originally Posted by AlKey
Try this
in B1
Formula:Please Login or Register to view this content.
v A B 1 [email protected]" [email protected]
Thanks, that was it.
I would love to know why the suggestions from post #2 didn't work for the OP.
My guess, is that wrong context was given when searching & replacing
This formula will work in all conditions like if there will be another character in right, it will remove
=SUBSTITUTE(A1,RIGHT(A1,1),"")
You are right about your suggested formula, but at no point in this thread did the OP state that the character would be anything other than the quotation mark, so AlKey's solution is absolutely on point, too, and does not need questioning.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks