ExcelBanter - CAN I SEPARATE SURNAME AND FIRST NAME IN 1 COLOMN INTO 2 COLOMNS?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - CAN I SEPARATE SURNAME AND FIRST NAME IN 1 COLOMN INTO 2 COLOMNS? (https://www.excelbanter.com/excel-discussion-misc-queries/147349-can-i-separate-surname-first-name-1-colomn-into-2-colomns.html)

findling

CAN I SEPARATE SURNAME AND FIRST NAME IN 1 COLOMN INTO 2 COLOMNS?

CAN I SEPARATE SURNAME AND FIRST NAME IN 1 COLOMN INTO 2 COLOMNS in EXCEL?
if you can answer this question please email me at
thanks.

Teethless mama

CAN I SEPARATE SURNAME AND FIRST NAME IN 1 COLOMN INTO 2 COLOMNS?

Select your range Data Text to Columns Next select Space Finish

"findling" wrote:

CAN I SEPARATE SURNAME AND FIRST NAME IN 1 COLOMN INTO 2 COLOMNS in EXCEL?
if you can answer this question please email me at
thanks.

All times are GMT +1. The time now is 10:55 PM.