adding data to an existing column with content

  • Thread starter Thread starter steve in bristol
  • Start date 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
 
Could you do a find and replace (on the XL menu under edit)
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dividing existing content into two cells 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Split column contents (de-concantenate) 7
Cell not calculating after importing data 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Comparing two columns 1
VBA - retrieve data on last create named range from previous inserted named range 0
Create List of Unique Values from several columns 2

Back
Top