From: Glenn on 11 Mar 2010 11:56 DaveR wrote:> I have a formula in cell G13 that shows "=B13*C13". Is there a way that i > can multiply cell B13 which has a number format and reads "61 Units" to cell > C13 which has a currency format and contains "34.23 / Ea" to get a value of > \$2,088.03 shown in cell G13? I don't know if I can show text in the cell > that is being referenced in a formula. > > Can you show text in a cell that is being referenced in a formula without > receiving the "#value!" in the formula cell? > > Thanks. Another way: =LEFT(B13,FIND(" ",B13)-1)*LEFT(C13,FIND(" ",C13)-1) From: Bob Phillips on 11 Mar 2010 12:57 But yours is a better way. I also thought of suggesting that, but just decided to give him a 'straight' answer :-) -- HTH Bob "pmartglass" wrote in message news:340DE78A-749E-4791-9579-285250533419(a)microsoft.com...>I like that > > "Bob Phillips" wrote: > >> Try >> >> =SUBSTITUTE(B13," Units","")*SUBSTITUTE(C13," / Ea","") >> >> -- >> >> HTH >> >> Bob >> >> "DaveR" wrote in message >> news:845C88D1-F217-4E0F-889E-84AAAD7FA35C(a)microsoft.com... >> >I have a formula in cell G13 that shows "=B13*C13". Is there a way that >> >i >> > can multiply cell B13 which has a number format and reads "61 Units" to >> > cell >> > C13 which has a currency format and contains "34.23 / Ea" to get a >> > value >> > of >> > \$2,088.03 shown in cell G13? I don't know if I can show text in the >> > cell >> > that is being referenced in a formula. >> > >> > Can you show text in a cell that is being referenced in a formula >> > without >> > receiving the "#value!" in the formula cell? >> > >> > Thanks. >> >> >> . >> First  |  Prev  |