Trimming off Mr & Mrs.

G

Guest

I have a name field that in some cases includes the name title for example
Mrs. Carol... or Mr. Thomas... I want to trim off the Mr. and Mrs. This
heading in not in all fields. I want only to see first and last name only.

Thanks for any help you can give!
 
T

Tony Williams

I would create 3 fields title, first name and surname then you can
concatenate them in any way you want
Tony
 
F

fredg

I have a name field that in some cases includes the name title for example
Mrs. Carol... or Mr. Thomas... I want to trim off the Mr. and Mrs. This
heading in not in all fields. I want only to see first and last name only.

Thanks for any help you can give!
Click to expand...

In a query:
Exp: Replace(Replace(Replace([CombinedNames],"Mr. and Mrs. ",""),"Mrs.
",""),"Mr. ","")
 
G

Guest

You can use the replace function in a Query

MyName: Replace(Replace([FieldName],"Mr. ",""),"Mrs. ","")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I concatenate title, firstname, middleinitial, lastname 4
Extract portions of text 2
Concatenate multiple records 3
How to sort a list with Mr, Mrs, Miss ? 5
Remove "Mr. & Mrs." from field 1
Drop down-list translation 2
DLookUp Criteria in a query 2
building a complicated (to me) string 4

Top