Help extracting characters from a cell value

Preparing Data
1

I have the following value

BAR//34556

and I need to extract just the numbers from the value. How can I do this?

2

There are a few ways to accomplish this.

  • Use the MID function to extract a values between 2 character positions
  • Use the SPLIT function to split the value on a specific character
  • Use the LEFT function to extract a given number of characters from the left side of your value

For more information on these functions visit: Functions