Hello,
I have a cell saying 'text' and I want to show it in another worksheet without the apostrophies: text.
The text is in varying size so can't use MID.
Any thoughts?
Many thanks!
Maya
Hello,
I have a cell saying 'text' and I want to show it in another worksheet without the apostrophies: text.
The text is in varying size so can't use MID.
Any thoughts?
Many thanks!
Maya
look at attachment I have changed ' for * because apostrophe in excel change cell In text format (test this and adjust to your needs)
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
That's perfect - thank you!!!
Maya
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks