Benches Uncategorized

1

Extracting only a portion of data from a …

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

I'm looks for a formula that will help me extract the numeric digits after the B if the content in a cell is B2984 for example. Many thanks

1 reply

Sign in or join Beachball Help to reply.

  1. 0

    SGIII

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Here are a couple of ways.

    The first is the easiest if you always have a B first followed by 4 numerals.

    The second will work if you have different numbers of numerals after B.

    There are many other ways. In your menu you can go to Help > Formulas and Functions Help and look in the Text

    Functions section.

    SG