p01 Kansas City Southern
Skip to main content

Recent Topics

xx
Dell PowerEdge R730 RAID
by Joe
Today at 10:06:52 AM

xx
KBA CIP3 software
by ScreamingCockatoo
February 16, 2019, 10:41:24 AM

xx
Prinergy 8.1.2 for sale
by abc
February 15, 2019, 05:50:39 PM

xx
Combine rows in excel to one row
by swampymarsh
February 15, 2019, 09:21:01 AM

xx
Markstools2 - State of the Industry?
by Joe
February 14, 2019, 08:41:20 PM

xx
Any Switch Users?
by abc
February 12, 2019, 05:04:27 PM

clip
"Processed with 'GPC'"? - What is this?
by ninjaPB_43
February 12, 2019, 04:05:46 PM

xx
PrePress/Printing Consultant?
by born2print
February 12, 2019, 03:34:19 PM

xx
CWS 5
by Possum
February 12, 2019, 11:13:30 AM

xx

xx
applescript to automator workflow...
by motormount
February 09, 2019, 01:42:18 PM

Topic: Excel question (Read 600 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.