Author Topic: Excel question  (Read 798 times)

0 Members and 1 Guest are viewing this topic.

Offline swampymarsh

  • Full Member
  • ***
  • Posts: 154
Re: Excel question
« Reply #15 on: August 28, 2018, 03:07:16 AM »
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.
« Last Edit: September 03, 2018, 02:16:55 AM by swampymarsh »