adding data to an existing column with content
 

I have columns with first names "Steve" and I want to them all to be
"Sunshine Steve" and I have another column with a letter ie "a" and I want to
make them all "24-a". Please advise

adding data to an existing column with content
 

Could you do a find and replace (on the XL menu under edit)
--
HTH...

Jim Thomlinson


"steve in bristol" wrote:

I have columns with first names "Steve" and I want to them all to be
"Sunshine Steve" and I have another column with a letter ie "a" and I want to
make them all "24-a". Please advise

adding data to an existing column with content
 

Jim,
Thank you...I didn't do a good job with my explanation...each name is
different as is the individual letter. So the first name column has steve,
tom, joe, etc and the letter column is ie, a, c, f, h, etc.

"Jim Thomlinson" wrote:

Could you do a find and replace (on the XL menu under edit)
--
HTH...

Jim Thomlinson


"steve in bristol" wrote:

I have columns with first names "Steve" and I want to them all to be
"Sunshine Steve" and I have another column with a letter ie "a" and I want to
make them all "24-a". Please advise

adding data to an existing column with content
 

Assuming names are in column A

In B1 ="Sunshine" & " " & A1 double-click on B1 filkl handle to fil down

Assuming letters are in column C

In D1 =24 & "-" and C1


Gord Dibben MS Excel MVP

On Mon, 5 May 2008 14:39:07 -0700, steve in bristol <steve in
wrote:

I have columns with first names "Steve" and I want to them all to be
"Sunshine Steve" and I have another column with a letter ie "a" and I want to
make them all "24-a". Please advise