ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Separating Full Names into First Middle and Last (https://www.excelbanter.com/excel-discussion-misc-queries/157537-separating-full-names-into-first-middle-last.html)

[email protected]
Separating Full Names into First Middle and Last
 
If I have a column on my worksheet that has full names, how can I separate
these into First, Middle and Last easily? Thanks.

Ron Rosenfeld
Separating Full Names into First Middle and Last
 
On Fri, 7 Sep 2007 17:44:01 -0700,
wrote:

If I have a column on my worksheet that has full names, how can I separate
these into First, Middle and Last easily? Thanks.

Data/Text to Columns/
Delimited
Select <space as the delimiter
--ron


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com