| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keep text out of numeric field | Setting up and Configuration of Excel | |||
| Formatting UserForm Text Field as Numeric | Excel Programming | |||
| Parsing Last Character in variable length text field | Excel Worksheet Functions | |||
| how do i step thru a text field looking for 6 numeric characters | Excel Worksheet Functions | |||
| parsing text field based on commas or spaces | Excel Programming | |||
Threaded Mode
