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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
What sort of Text? Descriptive?

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

$#,##0.00" Per Annum"

Gord Dibben Excel MVP
 
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
 
thegen said:
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
Click to expand...

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
 
Back
Top