How to break READEXCEL function if the line is too long

[PM_5157504]

1 ) Apparently, there is no substitute for copying and pasting a block of Excel cells in Prime as we could do in MathCAD 15.

2 ) This has forced me to use READEXCEL but unless I shorten all of the file names and work sheet names (in the READEXCEL function), the line runs off the right side of the printable area. I tried inserting a line break (Ctrl+Shift) but that didn't do anything inside the READEXCEL function.

Is there a way to break up the READEXCEL function at the comma? I don't want to rename files as that will make documentation less meaningful. I shortened the path to ".\" but the line is still too long.

[StuartBruff · Accepted solution]

Have you tried defining each element of the workbook name and worksheet name as string variables and using concat to build the longer, complete terms?  

For example:

You can break the path, etc names up into as many substrings as is convenient to read in your worksheet.

Stuart

[PM_5157504]

Thanks, that worked perfectly.

[Werner_E]

The page overhang of your READEXCEL command is not that large.

So you could help yourself either by predefining the path and filename in a variable and use that in the READEXCEL command and/or by choosing a smaller font size for this one command.

[StuartBruff]

And/or do what I did and use Landscape and Draft modes.

I suppose it's only really a problem if the Mathcad worksheet needs to be printed such that a reader can read the text without a magnifying glass.   <said in my favourite geriatric voice (think Methusalix from Asterix)> "Of course, back in my day, we could print out the right-hand pages.  None of this non-printing Draft mode nonsense, young fella, me lad."

[Catalina]

Hi @PM_5157504,

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution or please feel free to detail in a reply what has helped you and mark it as the Accepted Solution. It will help other members who may have the same question.
Please note that industry experts also review the replies and may eventually accept one of them as solution on your behalf.

Of course, if you have more to share on your issue, please pursue the conversation.

Thanks,

[PM_5157504]

Sorry, I neglected to mark the response as Accepted Solution. My bad.