News:

Main Menu

Excel question

Started by pspdfppdfxhd, August 21, 2018, 09:40:26 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

swampymarsh

#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.