I have a ton of data that is imported from our company's website. The data is displayed like this though "$100.00 (4 payments)". I need the dollar amount in this example, and in others I need the parenthesis data. I have tried using the Left() and Right() functions, but because nothing is static--some dollar amounts can be up to five figures--this does not work.
It would be fine if I could input the data as is, ie "$100.00 (4 payments)", in a chart or graph, but that is not possible. Any suggestions on how to do this with VBA?
Bookmarks