Share via

Is there a formula function that will remove alpha characters from a cell that contains both alpha and numeric characters?

Anonymous
2011-02-28T17:22:13+00:00

I have a range of data that has alpha characters on the left, but of varying length so the RIGHT function won't do the trick for me.  For example, one cell will have "CPAP-201010042001", while another cell has "ROBINSON-201008041888".  Several hundred rows of data would be very tedious to go line by line deleting the alpha characters at the front of the string.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2011-02-28T17:41:11+00:00

Using a formula...

A2 = CPAP-201010042001

=MID(A2,FIND("-",A2)+1,50)

Was this answer helpful?

6 people found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-02-28T23:50:12+00:00

    You're welcome. Thanks for the feedback!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2011-02-28T18:18:05+00:00

    Bingo!  Thanks for the quick response, this formula did the trick.  Thanks, Biff (T. Valko)... you have lived up to your billing as Community Star / Microsoft Excel MVP.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments