View Single Post
  #1   Report Post  
Jason
 
Posts: n/a
Default Can I create and save a formula for text fields?

I have a text field that has "Lastname, Firstname" and I would like to create
a second field that just shows the first name. Since I have a lot of names in
this format, I was thinking that I could create some kind of text formula in
Excel that would equal the original text field and delete everything up to
the comma. Can Excel do this using wildcards? Any suggestions?