Excel VBA Code to extract content from a cell

I need a VBA Code which separates the contents of a cell based on certain markers.

Text is Present in Sheet 1 in column 5.

There can be around 200 rows.

From columns 5 cells text has to be picked up one by one and separated into different rows.

After all rows have been populated then again changes have to be made based on 2nd category of markers.

Skills: Excel, Visual Basic, Visual Basic for Apps, Data Processing

See more: extract specific text from excel cell, excel vba extract string from cell, excel extract text from cell after character, excel substring delimiter, excel macro to extract text from cell, excel extract text from middle of string, how to extract a word from a string in excel, how to extract certain text from a cell in excel, excel vba code optmization, excel vba code optimis, vba code extract email text field, excel vba code log websites, outlook 2003 vba code extract data, excel vba code open internet explorer, inventory excel vba code, vba code extract email body, vba code extract data email, excel vba code check add ins, outlook vba code extract text, excel vba code data web page

About the Employer:
( 4 reviews ) Delhi, India

Project ID: #20419186

Awarded to:


hi i have experience in using excel VBA and i can complete the job in a short time. I'm new to this site and would be happy to start my first project. Ready to start, please message me to discuss your project in more More

₹600 INR in 3 days
(0 Reviews)

17 freelancers are bidding on average ₹1289 for this job


Hello, I have over 2 years with excel macros and Visual Basic for Applications. It is possible to complete this task in couple of hours of pure working time.

₹905 INR in 1 day
(366 Reviews)

Hello. I can do this work. Send me details with clear description..............................................

₹1200 INR in 1 day
(80 Reviews)

Hi, I can develop a macro to extract data from column 5, separate them and put into specific row and column. Macro can access variable number of rows so no matter how many rows are there. I am experienced Data Analy More

₹2250 INR in 1 day
(78 Reviews)

Hi, I am an excel VBA wiz and can do pretty much anything on an excel file. I went through your project description and excel file. I have developed many such macros to extract data from a column, separate them and More

₹2000 INR in 2 days
(52 Reviews)

Hi, I read all the necessities of your assignment and I must try to abide by all the requirements that you have mentioned in the project. If hired by you I will be responsible to complete the task within the stipulate More

₹1500 INR in 2 days
(8 Reviews)

Hi , I am an MBA professional have 4yrs of experience in Analytics, Tableau, Advanced Excel, vba and Python. I have done similar work and would be happy to share it with you to showcase my skills. Being an Analyst I us More

₹1050 INR in 2 days
(2 Reviews)

Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance Thanks

₹1250 INR in 1 day
(0 Reviews)

I have experience in Data entry(E-Publishing and Medical Billing) for more than 6 years. Well-known about data security and Protect about client information. we following HIPAA rules and regulations. I will do the job More

₹1050 INR in 6 days
(0 Reviews)

Hi, Hope you will be having a good day today. I have good command on MS Excel and VBA. Being an engineer, I am familiar with writing macros for Excel. I have done partly similar work where cells' text was counted and More

₹1500 INR in 2 days
(0 Reviews)
₹1300 INR in 1 day
(0 Reviews)

I have vast experience in VBA coding and separation of data with a cell can be automated so that the functionality/code can be reused in any other requirement within you organization. Relevant Skills and Experience Ha More

₹1300 INR in 2 days
(0 Reviews)

Hi, I am experienced vba macro developer and have delivered several projects of high complexity. looking at the description, I can complete this in 2 days. please share the sheet to be seperated with data. regards, More

₹1450 INR in 2 days
(0 Reviews)

Hi, This can be done using the formula as well as using macro. Macro will make your life easier but formula will keep your file lighter.

₹1200 INR in 7 days
(0 Reviews)

I am good in excel with vba, access, foxpro, visual basic programming, database development, database programming, sql , PHP, HTML. I assured you to work with in specified time and accuracy. Relevant Skills and Experi More

₹1300 INR in 2 days
(0 Reviews)

Hi! My name is Zeynep and I am a professional with high motivation. I have been working on Excel, Excel VBA and data analysis for a year and I am an expert on data entry and research. I am a fast learner and I have ado More

₹900 INR in 7 days
(0 Reviews)

I have 5 years of experience in VBA programming and excel development. You project might require use of RegEx. it will be completed in 1 day

₹1150 INR in 1 day
(0 Reviews)