Hi, I need a formula and eventually a macro that would change a certain original text format into another format. The original text contains recurrent terms such as "/", the letter A, "-" and "USAA". Before the "/" we can have an unlimited number of letters. The "A" is always after "/" then we see "YYMMDD" then the letter "C" or "P" with a number attached to it that can be unlimited as well. The goal is to rewrite into a different format: the date should be "MM/DD/YY", the "USAA" should be "US", the word "Equity" should be added, etc. You will see examples in the excel. Thank you
10 freelancers are bidding on average $4/hour for this job
Hello Sir I am Pola Essam ,Mechanical Engineer, I have great experience in data entry, word and excel and i have a passion to finish this work as fast as possible with no mistake with god's help
Hi, My name is parvez khan. i have had more than five years of experience in excel related work. I can able to perform this task successfully. Expecting your reply..