Hi,
I have an Excel sheet, that is I want to compare with another sheet but to apostrophe its giving the error.
Please help me to find out the formula for remove the apostrophe from the cell text value in Excel.
Thanks
Terressa
Hi,
I have an Excel sheet, that is I want to compare with another sheet but to apostrophe its giving the error.
Please help me to find out the formula for remove the apostrophe from the cell text value in Excel.
Thanks
Terressa
you get better help if you show the data of your file, without confidential information.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
as oeldere noted, a sample can go a long way to getting help. However, one formula that might help is =SUBSTITUTE(A1,"'","",1) and that will find ONE instance of the apostrophe and replace it with nothing.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Please attach a sample workbook. Then we can see what you're talking about!!
Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
-----Deleted-------
Agree w/Glenn, post a sample sheet so you can get specific help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks