Author Topic: Excel question  (Read 2581 times)

0 Members and 1 Guest are viewing this topic.

Offline swampymarsh

  • Full Member
  • ***
  • Posts: 160
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:

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.
« Last Edit: September 03, 2018, 02:16:55 AM by swampymarsh »