Hi and welcome

Difficult to say for sure without seeing a sample workbook (always easier to help if we can see the issue in context!), but perhaps there are extra characters at the end of your strings in column A that are "spilling" over into D-F?

You could always use formulas to extract the first / last names out too...

BSB