CODEWITHSUNDEEP
google-sheets
MichaelW
MichaelW

Reputation: 3

Google Sheets formula to Extract part of a string

I am in a pickle and need some help extracting portion of a string in a google sheet cell.

SM - Lead - LINE ITEM GOES HERE (ABC) - Jan $ 11.75 3,515.00 $ 41,301.25

I am looking to extract the amount after the second dollar ($) sign.

Thank you!

Upvotes: 0

Views: 119

Answers (2)

JPV
JPV

Reputation: 27252

Assuming the second dollar sign is always at the end of the string, you can also try

=regexextract(A2, "[^$\s]+$")

enter image description here

Upvotes: 1

Jason E.
Jason E.

Reputation: 1221

Assuming that the spaces and the format will be the same, you can try the formula below:

=REGEXEXTRACT(A1,"\$ \S+ \S+ \$ (\S+)")

This resulted to: enter image description here

Upvotes: 0

Related Questions