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 $21 for this job
I would love to work on your project. I read through the job details carefully and I am absolutely sure that I can do the project very well. I can complete your project on time and within your budget.