It's always much easier not to mix the data. Anyway, if the data posted is
representative (one comma, followed by the embedded number) and is in A1, and
you want to multiply it with a number in B1, you could try this in C1:
=B1*RIGHT(A1,LEN(A1)-SEARCH(",",A1)-1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jason Sewell" wrote:
Im trying to calculate some data in a cell that contains text and dollar
values. Ive put together an auction spread sheet for my fantasy baseball
league and Im trying to keep track of players and their dollar values in the
same cell. So one cell may contain €śJeter, 15€ť which really represents
Derek Jeter was sold for 15 dollars. I have formulas for keeping track of
dollar values, but they wont recognize that entry because the cell contains
text and a dollar value. Is there any way I can get excel to only see the
numerical value and ignore the text? Thanks in advance for the help.
Also, I realize I can put the number value and the name in a separate cell,
but Im trying to save space with the spread sheet.
Thanks again,