Andresleo47
Board Regular
- Joined
- Oct 29, 2008
- Messages
- 132
Hi Mr. Excel fellas! Hoping you're doing well.
The following are some of the values that I have in a single column:
332241
4321 - P1 W2 John Smith
Balance for Alvin James Fox
12345 - P10 W4 Carl Sagan
12345
Now, I need to put the initials of the names in the next column, so, the output would be
-
JS
AJF
CS
-
Any thoughts?
This is something I would truly appreciate!
Thanks so much,
AV
The following are some of the values that I have in a single column:
332241
4321 - P1 W2 John Smith
Balance for Alvin James Fox
12345 - P10 W4 Carl Sagan
12345
Now, I need to put the initials of the names in the next column, so, the output would be
-
JS
AJF
CS
-
Any thoughts?
This is something I would truly appreciate!
Thanks so much,
AV