Removing Text Spaces

M

mcp6453

I imported an email list. The only content in a cell is the the email
address followed by and space and then the recipient's name in
parentheses. Each address has several spaces before it. How can I
eliminate those spaces? I cannot just delete spaces, because of the
space between the email address and the first parentheses and because of
the space between the recipient's first and last name.
 
Top