extract Letters between Special Characters

[ravi2628]

HI Every one,


i need a output in the following format could any one please help me out


[TABLE="width: 500"]
<tbody>[TR]
[TD]Input[/TD]
[TD]Output[/TD]
[/TR]
[TR]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="class: xl65, width: 150"]10263AM/xbsdhbs[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="class: xl65"]10263AM[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="class: xl65, width: 150"]075893-SE-1[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="class: xl65, width: 150"]075893[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="class: xl65, width: 150"]052263[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 150"]
<tbody>[TR]
[TD="class: xl65, width: 150"]052263[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]


Thanks In Advance

Please Help me

 

[Gerald Higgins]

Hi - what are the rules for producing the output ?

Is it as simple as . . .
Search for a "/" character in the Input, and if found, output all characters to the left ?
If not, search for a "-" character in the Input, and if found, output all characters to the left ?
If not, output = input ?

If that's it, you can get that with . . .

=IFERROR(LEFT(A1,FIND("/",A1)-1),IFERROR(LEFT(A1,FIND("-",A1)-1),A1))

 

[Joe4]

We need you to clearly define that the phone are.
From the examples you posted, it looks like you want everything to the left of any "/" or "-" characters.
Is that correct? Are there any other characters we need to consider?

 

[bosco_yip]

To return everything in left of "/" or "-" character

=LEFT(A1,MIN(FIND({"/","-"},A1&"/-"))-1)

Regards
Bosco

 

[ravi2628]

Thank you

this condition satisfied my Logic