extract Letters between Special Characters

ravi2628

New Member
Joined
Dec 20, 2017
Messages
23
HI Every one,


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


InputOutput
10263AM/xbsdhbs

<tbody>
</tbody>
10263AM

<tbody>
</tbody>
075893-SE-1

<tbody>
</tbody>
075893

<tbody>
</tbody>
052263

<tbody>
</tbody>
052263

<tbody>
</tbody>

<tbody>
</tbody>


Thanks In Advance

Please Help me
 

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
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 . . .
Code:
=IFERROR(LEFT(A1,FIND("/",A1)-1),IFERROR(LEFT(A1,FIND("-",A1)-1),A1))
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,513
Office Version
365
Platform
Windows
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

Well-known Member
Joined
Dec 2, 2002
Messages
1,938
Office Version
2019
Platform
Windows
To return everything in left of "/" or "-" character

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

Regards
Bosco
 

Forum statistics

Threads
1,082,587
Messages
5,366,481
Members
400,893
Latest member
aoreilly2

Some videos you may like

This Week's Hot Topics

Top