Hire an Excel Expert
About Client
Source: – Freelancer
Client: – Alexandre Watson
Project ID: 15149852
Completion Date: – 12 Sep 2017
Project Details
Hello,
I have a number of excel tables that I need to clean. Basically this involves removing all spaces, punctuation and letters. Only two columns per table need to be cleaned and in all cases the cleaning is the same. My objective is for the values to be considered numerical.
This is a very simple task that either requires a lot of time or some Excel savvy to automatically remove line items.
I am uploading an example table. The columns titled “Prix” and “Superficie” are the ones that need to be cleaned. Notice there are multiple tabs. All tabs need cleaning. Other tables may be larger than this one, with more tabs and/or longer columns.
Thank you for helping me out!
Skills Required:
I have a number of excel tables that I need to clean. Basically this involves removing all spaces, punctuation and letters. Only two columns per table need to be cleaned and in all cases the cleaning is the same. My objective is for the values to be considered numerical.
This is a very simple task that either requires a lot of time or some Excel savvy to automatically remove line items.
I am uploading an example table. The columns titled “Prix” and “Superficie” are the ones that need to be cleaned. Notice there are multiple tabs. All tabs need cleaning. Other tables may be larger than this one, with more tabs and/or longer columns.
Thank you for helping me out!
Skills Required:
Excel
Testimonial
"Perfect service!"
