Excel Function
=LEFT(A1,FIND(",",A1)-1)
if (Jerry, Tom, Dave, Mark) is in A1, then above will return Jerry
"Shashi Bhosale" wrote in message
...
Hi,
I have a cell with value (Jerry, Tom, Dave, Mark), i want to find first
value (that is Jerry) from the list.
Which function i can use to acheive this.
Thanks in advance,
Shashi
|