Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Excel column changes
I would like to add a hypen and a number to each entry in cells within a
column. Each cell contains different info. Is there an easy manner to make this happen? -- JAKA |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Excel column changes
hi
an example of your data would have been nice but try this in a helper column... =A2 &"-1" regards FSt1 "KAD" wrote: I would like to add a hypen and a number to each entry in cells within a column. Each cell contains different info. Is there an easy manner to make this happen? -- JAKA |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Excel column changes
Before doing anything else, save a backup copy under a different name. Then
save the copy under the original name. So if you mess up, you can go to the backup copy. Use the CONCATENATE function and fill down. If you don't want the original cells to show up (say that your data's in column A and you put the formula in column B), highlight column B, right click, copy, then right click again, paste special, select values. Then you can delete column A without column B getting a lot of #VALUE errors. "KAD" wrote: I would like to add a hypen and a number to each entry in cells within a column. Each cell contains different info. Is there an easy manner to make this happen? -- JAKA |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Excel column changes
If you mean every cell would look like --
A-#### (A-12234; A-4785; A-2957,etc.) Then go to Format Cells, Number tab, Custom, and enter A-#### .... unless I am interpreting your question on a "too basic" level. "KAD" wrote: I would like to add a hypen and a number to each entry in cells within a column. Each cell contains different info. Is there an easy manner to make this happen? -- JAKA |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Excel column changes
Thank you for your help. Sorry, should have included an example. However, I
want to keep the information already in each cell and just add a hyphen and a number to the information. Each cell contains information such as, CS. I want to make it CS-1. The next cell contains, INST...want to make it INST-1 and so on down the list. Thanks. -- JAKA "FSt1" wrote: hi an example of your data would have been nice but try this in a helper column... =A2 &"-1" regards FSt1 "KAD" wrote: I would like to add a hypen and a number to each entry in cells within a column. Each cell contains different info. Is there an easy manner to make this happen? -- JAKA |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Excel column changes
"jiml" thank you for your response. Please see my reply to FSt1. I couldn't
reply to both of you at once. Or at least I didn't know how to. Thanks. -- JAKA "jiml" wrote: Before doing anything else, save a backup copy under a different name. Then save the copy under the original name. So if you mess up, you can go to the backup copy. Use the CONCATENATE function and fill down. If you don't want the original cells to show up (say that your data's in column A and you put the formula in column B), highlight column B, right click, copy, then right click again, paste special, select values. Then you can delete column A without column B getting a lot of #VALUE errors. "KAD" wrote: I would like to add a hypen and a number to each entry in cells within a column. Each cell contains different info. Is there an easy manner to make this happen? -- JAKA |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Excel column changes
hi
you can keep the original information. the helper column(Added) would house the new data. after you are happy with the results, copy the helper column and on the menu bar....editpaste specialvalues. this would turn the fomula into hard data. you can then delete the orginal column or archive it just in case. the helper column was not ment to add an extra column but to help in adding the additional data to the data already there. after that one of the columns in no longer needed. Regards FSt1 "KAD" wrote: Thank you for your help. Sorry, should have included an example. However, I want to keep the information already in each cell and just add a hyphen and a number to the information. Each cell contains information such as, CS. I want to make it CS-1. The next cell contains, INST...want to make it INST-1 and so on down the list. Thanks. -- JAKA "FSt1" wrote: hi an example of your data would have been nice but try this in a helper column... =A2 &"-1" regards FSt1 "KAD" wrote: I would like to add a hypen and a number to each entry in cells within a column. Each cell contains different info. Is there an easy manner to make this happen? -- JAKA |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Excel column changes
So what result did you get when you tried FSt1's suggestion?
It appears to do exactly what you asked for. -- David Biddulph "KAD" wrote in message ... Thank you for your help. Sorry, should have included an example. However, I want to keep the information already in each cell and just add a hyphen and a number to the information. Each cell contains information such as, CS. I want to make it CS-1. The next cell contains, INST...want to make it INST-1 and so on down the list. Thanks. -- JAKA "FSt1" wrote: hi an example of your data would have been nice but try this in a helper column... =A2 &"-1" regards FSt1 "KAD" wrote: I would like to add a hypen and a number to each entry in cells within a column. Each cell contains different info. Is there an easy manner to make this happen? -- JAKA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
Excel 2000: Adding column D based on value in column A | Excel Worksheet Functions | |||
how do I create multiple column width in the same column in excel | Excel Discussion (Misc queries) | |||
I need a customized Excel chart: Column - Column on 2 Axes | Charts and Charting in Excel |