but brother, u have mentioned only "-", i have lots of string in that like
*comma,
dash,bracket, * so how to combine all the special character in one.
On Friday, June 7, 2013 12:47:47 PM UTC+5:30, XLS S wrote:
>
> try below formula
>
> combination with Left and find formula
>
> =LEFT(G10,FIND(
try below formula
combination with Left and find formula
=LEFT(G10,FIND("-",G10)-1)
.
Enjoy
Team XLS
On Fri, Jun 7, 2013 at 12:13 PM, Rahul Sharma wrote:
> hi folks,
> i need a formula that can find the text string and remove from the name. i
> have 1500 name store
hi folks,
i need a formula that can find the text string and remove from the name. i
have 1500 name stored in my data, i presently i am doing manually, which is
lengthy process.
example
Guru Kirpa Distributor,Bathinda Guru Kirpa Spare Centre,Jalandhar Guru
Kripa Distributor-(Bathinda-Pb.) Gu
