Thread: Separating Full Names into First Middle and Last
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default 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
Reply With QuoteReply With Quote