LinkBack URL
About LinkBacks
how could i delete numerous words from various entries in excel data list
e.g. salman (Ali) Khan - i want to delete (Ali) from the cell value
please help out
deletion of words from list in excel
how could i delete numerous words from various entries in excel data list
e.g. salman (Ali) Khan - i want to delete (Ali) from the cell value
please help out
find (ali) replace with space?
or replace (*) to remove all () with a word in
Last edited by martindwilson; 02-06-2013 at 07:45 AM.
"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
I will rather explain the querry
salman (Ali) Khan
salman (Ahmed) Khan
salman (shah) Khan
Now please guide how can i remove the whole bracket, it a long list.
use find replace
in find put (*)
in replace put nothing click ok
Try this formula it will work exactly according to your requirement.
Please Login or Register to view this content.
Last edited by thameem127; 02-07-2013 at 11:33 AM.
Thank You Martin , this is so easy and very helpfull
@ martin
It is really fantastic thanks for your helpful answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks