a full example would be a bit large and over complicated
but i have attached somthing that i think gets what i am after
no i am looking to keep the cell as is
but the number is a length i need to multiply by a price per mm.
a full example would be a bit large and over complicated
but i have attached somthing that i think gets what i am after
no i am looking to keep the cell as is
but the number is a length i need to multiply by a price per mm.
I dont like to use code i dont understand
it makes it hard to use in other situations
so please try to be as clear and patent as possible with me
Criticism is welcomed
Perhaps:
![]()
D2: =$C2*MID($B2,FIND("=",$B2)+1,FIND("MM",$B2)-(FIND("=",$B2)+1))
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks