Text Project

[Joseph Horling]

Hi Chandoo,

My columns for my text project seem to be working except for a couple issues. 1) There is a comma between two last names (line 38) and there should be a hyphen. 2) On line 40, there is a comma between Van, Eaton and on line 38 a comma between Ashmun, Baker. Need to have a hyphen. 3) Also, sometimes there is no middle name and the last name appears in the middle name column(line45). 4)On line 44 has two last names with the first last name is the middle name column. Any clues on how to fix this? Thank you for your help. Joe, from Michigan.

 

[pecoflyer]

Thread closely related to https://www.excelforum.com/excel-new-users-basics/1334213-text-project.html

 

[Joseph Horling]

So what does that matter.....I want another opinion.

 

[vletm]

Joseph Horling
Forum Rules has an answer to Your what does that matter,
You should reread those

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

Especially part of cross-posting.
Here is other link to good to read about cross-posting:

Excelguru Help Site - A message to forum cross posters

post people forums answer issue forum cross time pointed free

www.excelguru.ca

Other note:
You have opened as well as in Chandoo.org:

polishing up a project

Hi Chandoo Experts, Hope all is well and staying safe. I need to ask you a favor. Can you update the formula in the first name column so I can get a space between Mr./Dr./Miss etc and the first name? Also, in the last name column I would like a hypen between the last two names. These are...

chandoo.org

Please, avoid to duplicate Your thread.