Hi, Ray-
It may not be elegant, but here's a workaround, at least: If your Names are all in column A, for instance, insert a new Column B and for each name cell write this formula: =A1 & " " This will add a space to the end of each name entry. Then copy column B and paste it back over itself as values, converting all the formulas to text. This will allow you to capture a "Jr", for instance, when it occurs in the middle of a name entry and at the end. |
All times are GMT +1. The time now is 04:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com