Insert < & > on a delimited list

M

maryrose

I want to insert the <> before and after the email addresses on a list
of 2000 for import into Entourage. There must be an easy way. What
might it be?

Thanks, MARY::confused:
 
P

Puppet_Sock

maryrose said:
I want to insert the <> before and after the email addresses on a list
of 2000 for import into Entourage. There must be an easy way. What
might it be?

Ok, you don't give a lot of information here. Like how you've got the
data
stored just now, or what Entourage needs in the way of a file, etc.

For example: Suppose the email addies were all in one column. That's
easy, you just insert columns on left and right, and fill the left with
<
and the right with >. Then you use that to construct the final data.
A little playing with column widths and saving as text, and you should
be able to get what you need.
Socks
 
P

Peo Sjoblom

If there are only email addresses you can simply use something like


="<>"&A1&"<>"


copy down, then copy and paste special as value

if not post back with what they contain


Regards,

Peo Sjoblom
 
Top