This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
In the primary field, I’m trying to create an ID Code for my ancestors and I need some help.
An example ID Code is:
First three letters of surname, first three letters of name, year of birth
eg Denis O’Brien born in 1836 = ObrDen1836
However, I have ...
augmented:
LEFT(SUBSTITUTE({last name},"’",’’),1)&RIGHT(LEFT(LOWER(SUBSTITUTE({last name},"’",’’)),3),2)
OMG that’s perfect! Thank you so so much Augmented. Have a wonderful day :pray: :grinning_face_with_big_eyes:
augmented:
LEFT(SUBSTITUTE({last name},"’",’’),1)&RIGHT(LEFT(LOWER(SUBSTITUTE({last name},"’",’’)),3),2)
Thank you so much for this help.
I’ve changed all the surnames to uppercase (which is standard in genealogy so that was a great tip) and I...
