Removing leading space

Please try

=SUBSTITUTE(A2,CHAR(160),)

This substitute formula provided by Bo_RY worked. Thank You so much

Employing Power Query, I brought your table into the PQ Editor. Applied the Trim function in the PQ Editor and then closed and loaded back to Excel.

Here is the Mcode for that

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Trimmed Text" = Table.TransformColumns(Source,{{" WearerFirstName", Text.Trim, type text}, {" WearerLastName", Text.Trim, type text}})
in
    #"Trimmed Text"

Power Query is also called Get & Transform. It is located on the data tab of the ribbon.

Review PQ
In the attached file
Click on any cell in the new table
On the Data Tab, click on Queries & Connections
In the right window, double click to open Query
Review PQ steps