Terminé

Need Macro to change text from 'Last, First' to 'First Last'

I have an excel sheet with a column of names. 90% of the names are set as "Last name, First name". The other 10% can be left alone.

I want a macro/code that checks if there is a comma (,) in the cell text. If so, it changes the text from "Last_name, First_name" to "First_name Last_name" (switches order, deletes comma and adds space between 'First_name' and Last_name')

------------------------------------------

Cell b2 reads: Smith, John A

Cell b3 reads: Jones, Tom

cell b4 reads: Adams, John Michael

These should be changed to:

John A Smith

Tom Jones

John Michael Adams

respectively.

-----------------------------------------------

There is about 1,250 text entries in the column so the more automated the better. I am not opposed to exporting it to .csv, changing it and then importing it back in if that's easier.

Due to the proprietary nature of the data, I cannot release the original worksheet but a mockup has been attached.

Thanks - please ask if you have any questions.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) a macro or code that can be easily installed and executed. installation assistance may or may not be necessary.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Microsoft Excel 2000

Compétences : PHP

en voir plus : smith hire, michael smith, michael jones, hire smith, first source, microsoft macro, last, hire macro coder, excel-to-csv, Excel to CSV, B3, b2, cell names, please worksheet attached, excel macro csv, excel macro program, change column, php macro, csv excel text, php excel macro

Concernant l'employeur :
( 92 commentaires ) Mecklenburg, United States

Nº du projet : #3279576

Décerné à:

ixyst

See private message.

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(78 Commentaires)
6.0

32 freelance font une offre moyenne de $18 pour ce travail

bzamfir

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(56 Commentaires)
7.3
TakeRealUK

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(552 Commentaires)
6.7
rengifojoel

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(69 Commentaires)
6.3
finecodervw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(165 Commentaires)
6.4
cbyteOZ

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(15 Commentaires)
6.3
techzonevw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(156 Commentaires)
5.8
thespreadsh

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(131 Commentaires)
5.4
vangelisdimou

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(61 Commentaires)
5.1
vw977443vw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(16 Commentaires)
4.7
brantcgardner

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(22 Commentaires)
4.5
vw594130vw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(65 Commentaires)
4.3
sqtech

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(15 Commentaires)
3.9
teckhuavi

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(13 Commentaires)
3.7
errrrus

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(12 Commentaires)
3.6
srsoftvw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(12 Commentaires)
3.5
johngalanopoulos

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(15 Commentaires)
3.4
yarila

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(15 Commentaires)
2.5
sebastianbran

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(4 Commentaires)
2.3
kbrad

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(4 Commentaires)
1.7
zealtechvw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)
0.5