ExcelBanter - how do i separate 2 strings of a cell in different cells?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i separate 2 strings of a cell in different cells? (https://www.excelbanter.com/excel-worksheet-functions/151788-how-do-i-separate-2-strings-cell-different-cells.html)

Bona

how do i separate 2 strings of a cell in different cells?

I have names and surnames both in a single cell?
I want to separate them in different cells.

Toppers

how do i separate 2 strings of a cell in different cells?

Assuming names separated by a blank only one forename plus surname):

=TRIM(LEFT(A1,FIND(" ",A1)-1))

=TRIM(MID(A1,FIND(" ",A1)+1,255))

HTH

"Bona" wrote:

I have names and surnames both in a single cell?
I want to separate them in different cells.

All times are GMT +1. The time now is 11:02 PM.