LinkBack URL
About LinkBacks
I have a long list of domains that look so (?Http://www.abcde.co.il/zurich/sites?).
I need to delete the "?" At the beginning and end of the string.
Using Find and Replace function I could not do it.
I have a long list of domains that look so (?Http://www.abcde.co.il/zurich/sites?).
I need to delete the "?" At the beginning and end of the string.
Using Find and Replace function I could not do it.
find ~? replace with nothing you need to precede ? with ~
because * ? and ~ are special wild card characters and to find/replace any of them you need to precede with ~ so
~~ ~* ~?
Last edited by martindwilson; 12-07-2013 at 08:23 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you
Some strings have ? In the middle of the string which I do not want to replace. What to do?
then youll have to use a function to extract then something like
=MID(A1,2,LEN(A1)-2)
Thank you very much
Here is with REPLACE function
=REPLACE(REPLACE(A1,1,1,""),LEN(A1)-1,1,"")
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
Well it works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks