Thread: How do I seperate a full name field out into three seperate columns?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rod Rod is offline
external usenet poster
  
Posts: 1
Default How do I seperate a full name field out into three seperate columns?
The name field is in the following format: Abbott, Susan H.


I would like to break it out into three seperate columns like below.

Last Name First Name Middle Initial
Abbott Susan H.

Reply With QuoteReply With Quote