Forum Discussion
Solved
Need to break up 1 cell into multiple columns (text has multiple conditions)
Need to break up 1 cell into multiple columns (text has multiple conditions) The source cell is as follows: Last, First, MI Rank USSF MAJCOM 123 SQUADRON/OFFICE Rank conditions are as follows: AB...
See if the attached workbook does what you want. I used some helper columns.
Not every name has a middle name but if they do it is in this format (w/o the point):
Lopez, Juan F
Lopez, Juan F
See if the attached workbook does what you want. I used some helper columns.
- Thank you so much! Code worked perfectly!