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

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

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

On 12 Apr 2004 15:49:45 -0700, (dan rube) wrote:

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

Select the cells.
Find
Replace

and be sure to tick Find entire cells only.


Regards Robert

"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


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.655 / Virus Database: 420 - Release Date: 09/04/2004