Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using mid find to either extract a number with 2 decimals or excludeFROM A STRING
Here is my data:
DEPOSIT 440.00 DEPOSIT 99.07 WZ404 TFR-FR 7119109 3,982.00 CHQ~00022-2300103934 4,426.00 BC HYDRO Q3L2Z5 86.33 SVC PLAN 2 FEE 16.95 I want my data organised in 2 columns as follows: Description Amount $ DEPOSIT 440.00 DEPOSIT 99.07 WZ404 TFR-FR 7119109 3,982.00 CHQ~00022-2300103934 4,426.00 BC HYDRO Q3L2Z5 86.33 SVC PLAN 2 FEE 16.95 Any help would be appreciated Thanks, Ed |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXTRACT NUMBER FROM STRING | Charts and Charting in Excel | |||
Extract number from text/number string.. | Excel Discussion (Misc queries) | |||
Extract Only Number From A String | Excel Programming | |||
How to extract the Number from a String | New Users to Excel | |||
Extract 2, 3, 4 or 5-digit number from string | Excel Programming |