In Progress

Renaming format in excel

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

Skills: Data Entry, Data Processing, Excel, Visual Basic, Word

See more: copy date text date format excel, format excel sheets, price comparison format excel, how to rename a tab on excel, rename sheet in excel vba, rename sheet in excel 2016, how to rename a sheet in excel without using mouse, how to rename an excel workbook, rename sheet in excel shortcut, rename sheet in excel 2010, unable to rename sheet in excel 2007, format excel spreadsheet track artist submissions, format excel finances, access vba open format excel spreadsheet, date format excel using vb6, format excel data, format excel datasheets, developing format excel, format excel word document, data sheet format excel

About the Employer:
( 0 reviews ) Dinajpur, Bangladesh

Project ID: #17834487

Awarded to:

dataEntryExperty

wil you please send me screen shoot or excel file contains data and the format which you want?

$2 USD / hour
(0 Reviews)
0.0
$7 USD / hour
(40 Reviews)
5.0

10 freelancers are bidding on average $4/hour for this job

maguirrer

Hello, I can do this jobs and start inmediately but there is no file attached on the post, please send me in a message to start working on it inmediately.

$2 USD / hour
(4 Reviews)
1.8
PolaEssam

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

$3 USD / hour
(3 Reviews)
1.9
x9sheikh

I'll take very short time to do it as I've high experience in all tools of MIcrosoft. So, let's come back to me I'll not let you down. Regards: Usama Nadeem

$3 USD / hour
(0 Reviews)
0.0
$5 USD / hour
(0 Reviews)
0.0
Parvez26

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..

$5 USD / hour
(0 Reviews)
0.0
$5 USD / hour
(0 Reviews)
0.0
ralphalmadin

I can finish this task with accuracy and punctuality since I am a data specialist and used to working in MS Excel Apps

$4 USD / hour
(0 Reviews)
0.0
yosuasutantooo

Trust me

$5 USD / hour
(0 Reviews)
0.0