Data Processing needed Very simple project just will take a little time

Hello,

I have an excel spreadsheet that has about 2,800 line items that need to be normalized so that our accounting software can help us decide on the individual line items and their classification.

Currently the line items look like this:

PAYPAL *ATORRESO XXX-XXX-XXXX CA XXXXXXXXX5264 XXXXXX867 ?MCC=8999

12/24 KANGAROO EXPRESS 1 MYRTLE BEACH SC 474165XXXXXX5264 082359463263899 ?MCC=XXXX

POS PURCHASE - FAMILY DOLLAR MYRTLE BEACH SC XXXX 00000000XXXXXXX

DEBIT CRD PUR INTL 12/11 REDSTATN INTERNET FAREHAM GB XXXXXXXXXXXXX 852347031842924 ?MCC=XXXX

We need a person to sit and take the above and make it so that just the description of purchase shows like this:

PAYPAL *ATORRESO

KANGAROO EXPRESS

FAMILY DOLLAR

REDSTATN INTERNET

I can send this in one text file so all thats needs to be done is to go through and delete the items that do not have a description

数据输入 数据处理 Excel

项目ID： #4323264

关于项目