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
"dan rube" wrote in message
om...
do you know how in Excel where I have in column 1 name
and (without < signs) in same colum
to do global change so all names in column 1 have < signs
Thanks Alot
dan