Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
IO currently have the following variable in one continuous line:
sTables = "* Basic Tables. TEMPORARY. NUMERIC T0000000. LEAVE T0000000. VARIABLE LABEL T0000000 'Table Total'. VALUE LABELS T0000000 0 ' '. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION " & myVars4ANOVA & " /TABLES (" & myVars4Table & ") BY (" & Groupvar & "+ T0000000) (STATISTICS) /STATISTICS mean( ( F7.2 ))." The program I am passing the variable sTables to needs sTables to look exactly like: sTables = "* Basic Tables. TEMPORARY. NUMERIC T0000000. LEAVE T0000000. VARIABLE LABEL T0000000 'Table Total'. VALUE LABELS T0000000 0 ' '. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION " & myVars4ANOVA & " /TABLES (" & myVars4Table & ") BY (" & Groupvar & "+ T0000000) (STATISTICS) /STATISTICS mean( ( F7.2 ))." so that there is a line break after each period mark. I cannot figure out how to create line breaks within the parentheses? Lance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Line breaks in Excel | Excel Discussion (Misc queries) | |||
Line breaks | Excel Discussion (Misc queries) | |||
unexpected line breaks in .csv | Excel Discussion (Misc queries) | |||
manual line breaks | Excel Discussion (Misc queries) | |||
Line breaks | Excel Worksheet Functions |