Simple ?
 

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

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

Simple ?
 

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

Simple ?
 

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