So, I'm cleaning up my file before mail-merging and I have a lot of results that include "50" in the names. I can't find a precise definition as to what this is but I'm guessing it's referring to an LLC?
To be perfectly honest with you, we have not seen something like this before. I'm not totally sure why there is a 50 appended to each owner name. It may be an LLC, but it seems like there is randomly the number 50 after individual owners. I would recommend removing this, as I don't think it's providing any meaning to the owner names.
Here is a link to some tricks for string splicing, which should allow you to remove the 50 from each name:
Hi Ed,
To be perfectly honest with you, we have not seen something like this before. I'm not totally sure why there is a 50 appended to each owner name. It may be an LLC, but it seems like there is randomly the number 50 after individual owners. I would recommend removing this, as I don't think it's providing any meaning to the owner names.
Here is a link to some tricks for string splicing, which should allow you to remove the 50 from each name:
https://exceljet.net/formula/split-text-string-at-specific-character
https://www.ablebits.com/office-addins-blog/2021/07/20/remove-text-numbers-from-string-excel/
Please let me know if this helps!