adding data to an existing column with content

  • Thread starter steve in bristol
  • Start date
S

steve in bristol

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
 
S

steve in bristol

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.
 
G

Gord Dibben

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
 
Top