Forum Discussion
Solved
Excel formula help
Hi all, I have a cell where it contains information such as below in cell A1. I want to use a formula to extract the dollar value of Orange (Navel) which is $1,091.49. This figure will change week o...
As variant that could be
=TEXTBEFORE( TEXTAFTER(D$3, E5 & " $") & CHAR(10), "." & CHAR(10),,,1 )*1for
and apply currency format to the result
As variant that could be
=TEXTBEFORE( TEXTAFTER(D$3, E5 & " $") & CHAR(10), "." & CHAR(10),,,1 )*1for
and apply currency format to the result
Thank you so much for your help. Greatly appreciated.
You are welcome