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

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to remove characters in a cell that precede a specific hyphen 17
Format that Omits Characters 7
check first 3 characters of a cell and compare to a table 4
How to lookup based in the first 3 characters of a cell 2
Remove data that preceeds a character 6
Format a Cell 1
How do I get more than 255 characters into a cell? 3
Format Cell and Data Validation 4

Top