| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple cells in a spreadsheet
If I have 279 cells with a part number in each cell and I want to add "Part
Number:" inside each cell how do I do it? Cell would originally be - AA55487-4 I want it to be - Part Number: AA55487-4 when I am done. Each cell has a unigue part number. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiple cells in a spreadsheet
Do you really want the cell contents to include 'Part Number: ' or just
the displayed value? IF the latter, select your column, choose Format/Cells/Number/Custom, and enter: "Part Number: "@ In article , idaho_mountainman wrote: If I have 279 cells with a part number in each cell and I want to add "Part Number:" inside each cell how do I do it? Cell would originally be - AA55487-4 I want it to be - Part Number: AA55487-4 when I am done. Each cell has a unigue part number. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiple cells in a spreadsheet
I would insert a new column (adjacent to the original) and a formula like:
="Part Number: " & a1 And drag down as far as I needed. idaho_mountainman wrote: If I have 279 cells with a part number in each cell and I want to add "Part Number:" inside each cell how do I do it? Cell would originally be - AA55487-4 I want it to be - Part Number: AA55487-4 when I am done. Each cell has a unigue part number. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
multiple cells in a spreadsheet
Thank You, that worked great.
"Dave Peterson" wrote: I would insert a new column (adjacent to the original) and a formula like: ="Part Number: " & a1 And drag down as far as I needed. idaho_mountainman wrote: If I have 279 cells with a part number in each cell and I want to add "Part Number:" inside each cell how do I do it? Cell would originally be - AA55487-4 I want it to be - Part Number: AA55487-4 when I am done. Each cell has a unigue part number. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I link cells in 1 spreadsheet to Specific cells in another | Excel Discussion (Misc queries) | |||
| A spreadsheet will not link to cells in another spreadsheet? | Excel Discussion (Misc queries) | |||
| macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
| make multiple cells in 1 worksheet equal multiple cells in another | Excel Worksheet Functions | |||
| How to extract cells from multiple spreadsheets into one new spreadsheet | New Users to Excel | |||
Linear Mode
