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