removing extra spaces
 

I am back again and, once again, have a long email list that I am going to
copy and paste from excel. For some reason this time every single cell has
about 30 extra spaces after the email address. So when I use the =j2&";"
function it puts the colon 30 characters after the email address... Any clue
how I can quick and easily get those spaces off of there??

Thanks in advance for any help...

removing extra spaces
 

Try

=TRIM(J2)&";"

Mike

"BVZ" wrote:

I am back again and, once again, have a long email list that I am going to
copy and paste from excel. For some reason this time every single cell has
about 30 extra spaces after the email address. So when I use the =j2&";"
function it puts the colon 30 characters after the email address... Any clue
how I can quick and easily get those spaces off of there??

Thanks in advance for any help...

removing extra spaces
 

Hi,

use the TRIM(A1) function
--
Thanks,
Shane Devenshire


"BVZ" wrote:

I am back again and, once again, have a long email list that I am going to
copy and paste from excel. For some reason this time every single cell has
about 30 extra spaces after the email address. So when I use the =j2&";"
function it puts the colon 30 characters after the email address... Any clue
how I can quick and easily get those spaces off of there??

Thanks in advance for any help...