removing extra spaces

[BVZ]

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...

 

[Mike H]

Try

=TRIM(J2)&";"

Mike

 

[ShaneDevenshire]

Hi,

use the TRIM(A1) function