Is it possible to have text and currancy in one cell and ...

[thegen]

Is it possible to have text and currancy in one cell and be able to use the
numbers in that cell to make an equation with another?

 

[JulieD]

well maybe depending on how the "text & currency" was arranged

for example if i have
$5 each
in cell A1
then in cell B1 i could have
=VALUE(LEFT(A1,SEARCH(" ",A1)))*10

which will return 50 which can then be formatted however you like.

Cheers
JulieD

 

[Gord Dibben]

What sort of Text? Descriptive?

Perhaps some kind of Custom Format like.........

$#,##0.00" Per Annum"

Gord Dibben Excel MVP

 

[thegen]

thanks for your replies we are getting close
i'll give you an example
Unbleached hand towel $2.00 (text and currancy need to be in one cell)
i want to be able to multiply the $2.00 to a number in he quantity column

 

[Max]

thanks for your replies we are getting close
i'll give you an example
Unbleached hand towel $2.00 (text and currancy need to be in one cell)
i want to be able to multiply the $2.00 to a number in he quantity column

One way ..

Assuming you have this table in cols A to C
data from row2 down

Item_____________________Qty___TotalCost
Unbleached hand towel $2.00_100__$200.00
etc

(where the item price is always located
right at the end of the text-string in col A)

To compute the "TotalCost" (col C)

Put in C2: =B2*MID(TRIM(A2),SEARCH("$",TRIM(A2))+1,99)+0
Format C2 as currency and copy down