delete spaces between last name and first name

R

Ra

Hi,

I have a table downloaded from a site with a list of names like that:

Alameddine, Jacob
ALBRECHT, DAVID
Alcantara Plata, Rigoberto
BARTOLOMEO, ANTONIO

I need to get the names with no spaces in between the last name, and first
name, such as:

Alameddine,Jacob
ALBRECHT,DAVID
Alcantara Plata,Rigoberto
BARTOLOMEO,ANTONIO

Any idea son how I can put a condition in a query or SQL?

Any help would be greatly appreciated.

Thank you,
 
F

fredg

Hi,

I have a table downloaded from a site with a list of names like that:

Alameddine, Jacob
ALBRECHT, DAVID
Alcantara Plata, Rigoberto
BARTOLOMEO, ANTONIO

I need to get the names with no spaces in between the last name, and first
name, such as:

Alameddine,Jacob
ALBRECHT,DAVID
Alcantara Plata,Rigoberto
BARTOLOMEO,ANTONIO

Any idea son how I can put a condition in a query or SQL?

Any help would be greatly appreciated.

Thank you,
Click to expand...

NoSpace:Replace([FieldName],", ",",")

The above will only remove the space after the comma, and leave any
spaces within the name ,if any, i.e. van den Steen,Henry
 

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

Switch Last Name First Name to First Name Last Name 2
Trim trailing spaces for name field in query 4
How to fix spaces between last name comma first name 8
Split the contents of a field ie - full name into first and last n 3
Excel Newb: Splitting First name and Last name 1
Splitting Names 2
Field with both first name and last name 2
Excel to Word to PDF workflow 1

Top