Thread: using mid find to either extract a number with 2 decimals or excludeFROM A STRING
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] edwardsoares000@gmail.com is offline
external usenet poster
  
Posts: 2
Default 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


Reply With QuoteReply With Quote