KimprintCreative
New Member
- Joined
- Sep 25, 2014
- Messages
- 5
Hello! So, I have a spreadsheet with the title, first name, middle initial, last name, and suffix in one cell. Using a formula, is there a way I can split all of this and, if a cell does not have all four components, just have it fill in what it does have?
So...
A1 = Rev. Kimberly E. Holmes, DMin
B1 = Rev.
C1 = Kimberly
D1 = E.
E1 = Holmes
F1 = DMin
Sometimes the title will be a full one (Pastor, Minister, etc) and sometimes an abbreviated one (Dr., Atty,. etc).
Thank you in advance to anyone reading this who can/will offer help and thank you to the mods in case I have posted this in the wrong place or am asking a question that has already been answered.
So...
A1 = Rev. Kimberly E. Holmes, DMin
B1 = Rev.
C1 = Kimberly
D1 = E.
E1 = Holmes
F1 = DMin
Sometimes the title will be a full one (Pastor, Minister, etc) and sometimes an abbreviated one (Dr., Atty,. etc).
Thank you in advance to anyone reading this who can/will offer help and thank you to the mods in case I have posted this in the wrong place or am asking a question that has already been answered.