Is there a formula to sepparate just the first letter of a cell, then the first of middle name in to adjoining cell then the first letter of last name in the next cell?
For instance: Cell A2="John Albert Smith
How do I get Cell B2 to contain "J"
C2 to contain "A"
D2 to contain "S"