Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Excel 2003: SP2
Greetings: Gleaned info from this ng, but having trouble making it work. Data in C: Description Column Data in D: Unit of Measure Column: Fixed width of 10 required Data in E: QTY Column: Fixed width of 6 required Concatenated result should be: D & E & C =LEFT(D23&REPT(" ",10),10) 'This work great. =LEFT(D23&REPT(" ",10),10) & LEFT(E23&REPT(" ",6),6) This returns as "Value" Then I still also need to "add" column C. Help, please |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I have different column widths below each other | New Users to Excel | |||
Column Widths | Excel Discussion (Misc queries) | |||
Different column widths | Excel Worksheet Functions | |||
Column Widths | Excel Worksheet Functions | |||
Column widths | Excel Worksheet Functions |