Hello all,
I have a list of my customers with their name and surname in the same cell/column. I want to create a column with their names only and another with their surnames only.
I have tried left and if + text formulas, but did not find the proper way.
Can you help please?
Thank you,
Angelos
I have a list of my customers with their name and surname in the same cell/column. I want to create a column with their names only and another with their surnames only.
I have tried left and if + text formulas, but did not find the proper way.
Can you help please?
Thank you,
Angelos