View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SunRay SunRay is offline
external usenet poster
 
Posts: 1
Default Seperating Text in One Field into 2 Fields EG FullName

I have a spreadsheet that I have a list of Employees names. Unfortunately the
List has there full names and I want to seperat them into First Name and
Surname. the First Name Has a space after it before the surname starts.

EG
FullName
John Smith

I want to seperate these into
First Name Surname
John Smith

Any Help would be very appreciated,