| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a Custom Column based on an existing Column (EXPERT) | Excel Worksheet Functions | |||
| Adding data to existing data that has a unique number in column | Excel Discussion (Misc queries) | |||
| Adding a Baseline Value into my existing column graph. | Excel Worksheet Functions | |||
| adding extra text into an existing column | Excel Worksheet Functions | |||
| Adding more source data to existing scatter plot | Charts and Charting in Excel | |||
Hybrid Mode
