Simple ?

[dan rube]

do you know how in Excel where I have in column 1 name <[email protected]>
and [email protected] (without < > signs) in same colum
to do global change so all names in column 1 have < > signs

Thanks Alot

dan

 

[Anne Troy]

Suppose the addresses without the symbols are in column B, beginning in row
2.
In C2, type:

="<"&B2&">"

Copy the formula down. Copy all the cells with the new syntax. Edit-Paste
special as values.
Delete column B.

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com

In another column

 

[David Prout]

Assuming addresses start in cell A1 enter in cell B1

=if(left(A1,1)="<",+A1,+"<" & A1 & ">")

Copy down as far as necessary

convert them back to text using Edit/Paste/Special Values

DavidP

 

[Robert McCurdy]

Select the cells.
Find [email protected]
Replace <[email protected]>

and be sure to tick Find entire cells only.


Regards Robert