Returning Partial String

Ronald Anderson

Hello - Is there a function that can return only the number values in the below example?

Kelsey Comeau (204938)

Thanks!

Ron

Paul Newcome

You would use something along the lines of...

=MID([Column Name]@row, FIND("(", [Column Name]@row) + 1, FIND(")", [Column Name]@row) - (FIND("(", [Column Name]@row) + 1))

Paul Newcome

You would use something along the lines of...

=MID([Column Name]@row, FIND("(", [Column Name]@row) + 1, FIND(")", [Column Name]@row) - (FIND("(", [Column Name]@row) + 1))

Ronald Anderson

Exactly what I needed.

Thank you!

Paul Newcome

Happy to help. 👍️