Formula Help

  • Thread starter Thread starter Lee-Anne Waters via AccessMonster.com
  • Start date Start date
L

Lee-Anne Waters via AccessMonster.com

Hi,

i have a table that contains names like leeanne.waters

what i need to be able to do is use a formula to extract the first name only
(ie everything before the dot.)

many thanks for your help

Lee-Anne
 
Hi,

i have a table that contains names like leeanne.waters

what i need to be able to do is use a formula to extract the first name only
(ie everything before the dot.)

many thanks for your help

Lee-Anne
Click to expand...

FirstName = Left([FullName],InStr([FullName],",")-1)
 
Back
Top