Hi
=LEFT(A2,FIND("_",A2&"_")-1)
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answe
Dear Saurabh,
you can also use..
=IFERROR(LEFT(A2,SEARCH("_",A2,1)-1),A2)
See the attached sheet.
On Thu, Feb 2, 2012 at 3:59 PM, Saurabh Madhusudan Patel <
saurabh.pa...@in.aegisglobal.com> wrote:
> Hi,
>
> ** **
>
> I have list with the values. I need only text which comes before “*_*”.
Dear Saurabh
Kindly find the attached file
On Thu, Feb 2, 2012 at 3:59 PM, Saurabh Madhusudan Patel <
saurabh.pa...@in.aegisglobal.com> wrote:
> Hi,
>
> ** **
>
> I have list with the values. I need only text which comes before “*_*”.
> Please find attached herewith the file. I want the res
see the attached
=IF(ISERROR(LEFT(A2,FIND("_",A2)-1)),A2,LEFT(A2,FIND("_",A2)-1))
On Thu, Feb 2, 2012 at 3:59 PM, Saurabh Madhusudan Patel <
saurabh.pa...@in.aegisglobal.com> wrote:
> Hi,
>
> ** **
>
> I have list with the values. I need only text which comes before “*_*”.
> Please find a
Hi,
I have list with the values. I need only text which comes before "_". Please
find attached herewith the file. I want the result shown in the highlighted
cell.
Required formula with out doing text to column.
Regards,
Saurabh Patel
DISCLAIMER:The information contained in this
