Devam Ediyor

519814 Split Field In Excel Spreadsheet

I have an Excel spreadsheet with a Contact column that has the contact's full name and title, like this: John Q. Doe, Director of Marketing.

I need three new columns created with the data from this column: a First Name column, a Last Name column, and a Title column. So in the case of this row, the First Name = John, the Last Name = Doe, and the Title = Director of Marketing.

Notice that (1) any middle initials and the periods after middle initials are eliminated, (2) the comma after the last name is eliminated, (3) if commas or periods occur in the title, they should not be eliminated, and (4) in the newly created fields, there should be no spaces after the data.

There are 725 rows in the spreadsheet.

Beceriler: Her şey Kabul, Excel, Pazarlama

Daha fazlasını görün: split full name excel, Field marketing , director of marketing, excel split columns, spreadsheet 2, split, row spreadsheet, initials, excel spreadsheet, excel doe, spreadsheet columns, excel row column, excel split, excel column row, doe excel, column row excel, excel rows, excel spreadsheet field, marketing excel spreadsheet, fields excel spreadsheet, excel spreadsheet marketing, director contact, excel row columns, split data, rows excel

İşveren Hakkında:
( 8 değerlendirme ) Boulder, United States

Proje NO: #2265750

Seçilen:

bhupal123

====== Hello halsegal, will do it right now. Please check PMB. Thanks. ======

0 gün içinde 10$ USD
(554 Değerlendirme)
6.5