p01 Kansas City Southern
Skip to main content

Recent Topics

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

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

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

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

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

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

xx
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:
(\b[a-zA-Z]{1}\b)

Or perhaps this search:
(?i)(\b[a-z]{1}\b)

Or even:
(\b[[:alpha:]]{1}\b)

Then use a replace entry such as:
$1.

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.