How To Use TEXTSPLIT Function In Excel To Split Out The Names In Column Simplified
How To Use TEXTSPLIT Function In Excel To Split Out The Names In Column Simplified
Formula
=TEXTSPLIT(B2," ")
This will split out the names of the staff to 3 different columns accordingly. Kindly ensure that the names of the staff are been separated out by space.