Kapalı

Excel Macro to separate users with semicolon in a new line

I have a large list of users of format LN, FN MN separated by semicolons. I want it arranged in a new line.

Example:

Bill, John J;Joseph, Maria

Parker, John

Joseph, Mark R;Kim, Peshardy

Sam, Joe

Mark, Joe;Tiller, Mark M;Koni, Joe

Output:

Bill, John J

Joseph, Maria

Parker, John

Joseph, Mark R

Kim, Peshardy

Sam, Joe

Mark, Joe

Tiller, Mark M

Koni, Joe

Budget $35-45

Beceriler: Excel, Visual Basic

Daha fazlasını gör: software to write the chip, software read write data smart card, software rfid write tag, rfid software read write, software read write emv chip, software description write, software need write ipad app, custom software request write, software engineering write requirement proposal, software project write ups, software program write book, software product write specifications, ebook software formate write, software need write java, software application write business letters company project letterhead, excel macro separate number sign, excel macro separate lotto numbers, creating macro copy excel paste program, macro updating excel macro, excel macro filling excel sheet, vba word macro refrence excel range, macro script excel, macro copy excel website, vba split separate excel, macro solidworks excel

İşveren Hakkında:
( 73 değerlendirme ) dallas, United States

Proje NO: #14615694

Bu iş için 83 freelancer ortalamada $56 teklif veriyor

jaylancer43

Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-st Daha Fazla

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(569 Değerlendirme)
8.2
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this this task as per your requirement Relevant Skills and Experience I have the 5 years Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(228 Değerlendirme)
7.4
FINGERRPRINT

We can use simple formula to separate and get the data in new line. Looking forward to work in this project. Relevant Skills and Experience Completed many similar work before. Thanks Proposed Milestones $34 USD - Mil Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(177 Değerlendirme)
7.3
Khurramz

How to arrange in new line? Could you please send me output format? Relevant Skills and Experience Excel Proposed Milestones $45 USD - .

in %bids___i_period_sub_35% gün içinde45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(311 Değerlendirme)
7.3
RSwapnil

I can arrange names in require format. I can complete the job within a day. Looking forward to work with you

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(239 Değerlendirme)
7.3
sergiuloghin

Hello! I can create the macro right now and finish in a couple of hours. You will not be dissapointed, i have a big 37% rehire rate. Thank you! Relevant Skills and Experience excel expert Proposed Milestones $30 USD Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(152 Değerlendirme)
6.8
SBITServices

Hello TUXSERVICES, It is very simple task. It needs just 2 excel formulas. I am ready to do it and finish it in 10 [login to view URL] my reviews to confirm my work quality(100%completion rate) Relevant Skills and Experience Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(291 Değerlendirme)
7.1
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm is still working on this proposal.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(254 Değerlendirme)
7.0
ksriniravi

I can develop a macro for $35. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 12 MONTHS , spent at least 225 Daha Fazla

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(148 Değerlendirme)
6.6
in %bids___i_period_sub_35% gün içinde39%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(123 Değerlendirme)
6.6
Venkat2011sri

Hello, Thanks for the opportunity to bid on this project. Task is 100% clear and i will get this done for you. We promise you 100% quality within the time limits. Relevant Skills and Experience Data Entry Proposed Mi Daha Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(145 Değerlendirme)
6.6
in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(244 Değerlendirme)
6.3
paris2785

I've read your brief and can see that you'd like to have an Excel spreadsheet to split names. Relevant Skills and Experience I have 7 years experience designing and developing Excel spreadsheets filled with formulas Daha Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(136 Değerlendirme)
6.6
ZedExcel

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(30 Değerlendirme)
5.8
Attractionnet

Hi. I have done any jobs like this one. I will create a small application in visual basic which will do this in few minutes. Relevant Skills and Experience I'm a programmer, I create custom programs for any purpose P Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(96 Değerlendirme)
5.9
bilalmaher053

hi, i can do this, can we discus about project in PM? Thanks...

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(111 Değerlendirme)
5.7
axiomswb

We have expertise in excel VBA,webscraping, data [login to view URL] satisfaction is our main motto for long term relationship.

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(41 Değerlendirme)
5.7
vlayausa

Hello, I would love to help. Relevant Skills and Experience As we spoke before, I believe I could do this project for you. And since you already paid, I would do it for you for free. Proposed Milestones $40 USD - a

in %bids___i_period_sub_35% gün içinde40%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(126 Değerlendirme)
5.8
finecodervw

Hi, I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have done good amount of work in Excel m Daha Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(66 Değerlendirme)
5.5
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(54 Değerlendirme)
5.5