Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help With String Concatenation
On Sep 16, 6:57*am, "tb" wrote:
I am trying to create a simple part number configurator using an Excel spreadsheet. *(I am using Excel 2007) * *Cell B3 is where the user enters the base part number (i.e. the code * *assigned to the base part without any add-on components). *That will * *always have to be entered manually by the user. * *Cells D2 - AC2 have codes that specify all the add-on components that * *could be assembled with the base part. * *Cells D3 - AC3 is where the user inserts an "X" and selects which * *add-on component (options) will be added to the base part. * *Cell AD3 would be a concatenated string composed by the base part * *number (cell B3), a dash (-), and the codes of any of the add-ons * *shown in cells D2-AC2 and selected with an "X" in cells D3-AC3, each * *one separated by a forward slash (/). *This would be the complete * *part number of the assembled product. For instance: * Cell B3 shows "C6520" as the base part number. *(This will always have * to be inserted manually.) * Cells D2-H2 have codes such as "AG", "AI", "AR", "BE", "BL". *(Note: * I am only showing the first five options instead of the full 26!) * Cells D3, F3, and H3 have an "X" in their cell. * The part number string in cell AD3 would be: *C6520-AG/AR/BL I really would prefer an Excel formula rather than a macro... Thanks. -- tb How about a user defined function, rather than a macro? xt |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help With String Concatenation
On 9/15/2011 at 3:33:43 PM Xt wrote:
How about a user defined function, rather than a macro? xt I am willing to give it a try but I don't know how to create a user-defined function. So, if you are willing to post instructions and code I am all hears... :-) Thanks. -- tb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenation help | Excel Worksheet Functions | |||
Concatenation | Excel Discussion (Misc queries) | |||
Help with Concatenation | Excel Worksheet Functions | |||
Bold in string concatenation | Excel Discussion (Misc queries) | |||
How do I put each member of string concatenation in its own line? | Excel Worksheet Functions |