How can I copy characters from a cell that follow a hypen

[brantty]

I have a cell that has data followed by a hyphen then more data.
EX> 12345-ABC456123-more data

I want to copy the first three characters that follow the hyphen so my cell
looks like:

EX> ABC

What formula will look to the original cell and remove all the info but keep
the three characters I need?

 

[Elkar]

Try this:

=MID(A1,FIND("-",A1)+1,3)

HTH,
Elkar

 

[brantty]

That worked great. Thanks

Try this:

=MID(A1,FIND("-",A1)+1,3)

HTH,
Elkar