p01 Kansas City Southern
Skip to main content

Recent Topics

Time Machine and OS Install
by Tracy
Today at 12:40:23 PM

New Windows 10 PC
by Tracy
Today at 11:37:40 AM

Poll: Work Lighting
by Tracy
Today at 09:42:12 AM

Office 365 Outlook
by frailer
December 09, 2018, 05:13:58 AM

Whole of job corruption upstream?
by frailer
December 09, 2018, 05:10:44 AM

A way to find a pdf page size from acrobat reader?
by Tracy
December 06, 2018, 02:55:57 PM

Paper "scam"
by born2print
December 06, 2018, 12:23:25 PM

Topic: Excel question (Read 507 times) previous topic - next topic

Re: Excel question

Reply #15
Another option would be to use a regular expression based search/replace.

Copy the entire name column into a regex/grep capable text editor.

Use a find command entry such as:

Or perhaps this search:

Or even:

Then use a replace entry such as:

Then copy/paste the result back into Excel.

Keep in mind that this will add a period character after any single alphabetical character that has white space on one or both sides, so double check that this makes sense with your data.

Screenshot attached to illustrate.