Thread: Simple ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Anne Troy[_3_] Anne Troy[_3_] is offline
external usenet poster
 
Posts: 16
Default Simple ?

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