View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PhxDelta PhxDelta is offline
external usenet poster
 
Posts: 4
Default Split LastName, First Name column into 2 seperate columns

Hi, I inherited a worksheet with a combined Name column. Some entries are
listed as "FirstName LastName" and others are "LastName, First Name ". How
do I split all of the names out into two new columns "LastName" and "First
Name"? Thanks.