In cell a96 I have "$82 Million Cash Value $51.4 Million"
I need b96 to show 82000000 which i can do with =VALUE(TRIM(LEFT(A69,LEN(A69)-33)))*1000000
but am concerned that may not always work as I never know the digit count thus throwing it all off.
I also need c96 to show 51400000 - and again same concern.....
The text 'Million Cash Value' in middle and 'Million' at the end end will always be there....
Any suggestions?
Try in B96:
C96:
Please Login or Register to view this content.
Please Login or Register to view this content.
Quang PT
Enter in B96 and copy across to C96
Formula:
Please Login or Register to view this content.
v A B C 95 96 $82 Million Cash Value $51.4 Million 82000000 51400000
Last edited by AlKey; 11-11-2017 at 09:48 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Both of your answers worked.... Looks like now I will be looking into the search and rept commands.... thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks