extract numbers / text from a column

Hello experts,

how to extract numbers and text from column A to column B as follow:

Data (column A)                              result  (column B)
88888-AMERICA S                              88888-AMERICA
88888-008-08                              88888-008
Leonardo MAsked:
Who is Participating?
Rgonzo1971Connect With a Mentor Commented:

pls try
=IF(ISERROR(FIND("-",A1,FIND("-",A1)+1)),IF(ISERROR(FIND(" ",A1,FIND("-",A1)+1)),A1,LEFT(A1,FIND(" ",A1,FIND("-",A1)+1))),LEFT(A1,FIND("-",A1,FIND("-",A1)+1)-1))

Open in new window

Rob HensonFinance AnalystCommented:
Can you expand on the basis of the split between the two segments of data??

The first example drops the last two characters, the second drops the last 3 characters.

To drop last two characters:

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.