bencar
Banned user
- Joined
- Jun 8, 2016
- Messages
- 149
I wish to split the following names into separate cells. Entries with 1st, middle and last names are split normally into 3 separate columns. But entries with no middle names have an issue. Their last names are placed in the 2nd column as if it were their middle names. How can I fix it so that the last name of entries with no middle name go to the 3rd column (for last names) instead of the 2nd column which is reserved for middle names?
<tbody>
</tbody>
ann edwards sarah |
yolanda m. dara |
herman lopez |
miike z. boro |
jen yanna |
<tbody>
</tbody>
Last edited: