Completed

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

See more: copy date text date format excel, format excel sheets, price comparison format excel, how to rename excel file, rename multiple excel sheets from list, rename multiple tabs in excel, how to rename a sheet in excel without using mouse, rename sheet in excel vba, how to rename a tab on excel, rename sheet in excel 2010, rename sheet in excel shortcut, 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 ) Alsip, United States

Project ID: #17834016

Awarded to:

SidhuDN

Hi, I have checked the job details & interested to work on. Please consider my proposal. Rgds, Sidhu

$25 USD in 1 day
(14 Reviews)
4.7

10 freelancers are bidding on average $21 for this job

bdoutsource

Hi, Greetings. It could be done through a formula. If you are interested, would share you. Thank you.

$30 USD in 1 day
(180 Reviews)
6.6
satishtl

- Went through the Excel the current and the desired format. Original format Desired format TSLA/A180921C285-USAA TSLA US 09/21/18 C285 Equity Using macros or formulas this can be bu More

$30 USD in 1 day
(51 Reviews)
6.1
Aishwaryakumari

Hello, I have experience in MS Office and Data entry for more than 4 year's, excellent skills and knowledge in MS Office have helped me to grow, so with my interpersonal skills and experience i would be able to comp More

$10 USD in 1 day
(0 Reviews)
0.0
ritajee

Hello, I have read and understood your requirements. I am highly experienced in data management having perfect knowledge in VBA, Excel, Web Technology, PHP, MYSQL, SQL, Excel, PDF and many more. I can easily handle More

$20 USD in 1 day
(0 Reviews)
0.0
$15 USD in 1 day
(0 Reviews)
0.0
ratheeshan

HI I Will finish your work within a couple hours guaranteed with great results I've got many years of experience in excel and data entry

$20 USD in 1 day
(0 Reviews)
0.0
syedmuhammadsm23

Its esay ill do thats Relevant Skills and Experience I done exel i knw how to do this

$25 USD in 1 day
(0 Reviews)
0.0
dgdushyant

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.

$14 USD in 1 day
(0 Reviews)
0.0
MartinJimmyCart

I have a lot of time and experience with that type of work, am really good with excel, I would want to be of help in any way I could.

$25 USD in 1 day
(0 Reviews)
0.0