View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
u473 u473 is offline
external usenet poster
 
Posts: 184
Default Parsing a text field to retrieve numeric values

I have been given a table in wich each cell of column A contains the
following
text format for 4 numeric values.
Value1 x Value2 x Value3 x Value4
like 30x140x50x120

How do I retrieve each of the 4 numeric values,
and populate column B as (Value1 * Value2 ) + (Value3 * Value4)

The second "x" multiplier is misleading and could have been left out
but this is how the table was improperly populated and I have to cope
with it.

Help sincerely appreciated,