Excel Create a New line in a Word Link without double "" around result

S

sirplus

Joined
Sep 8, 2009
Messages
4
Reaction score
0
How to get this Result
1234
5678
to appear in a word link to excel

In Excel I'm using a Formula like
=SUBSTITUTE("1234546","4",CHAR(10) & "4")

I have another formula which returns something variable instead of "123456" only if I can get this working with "123456" that will be a good start..

I have a link in a word doc and I'd like to have the line break appear in the result.
LINK Excel.SheetMacroEnabled.12 "C:\\MyFile.xlsm" MySheet!MyNamedRange \t \* CHARFORMAT

My field works only the result is always surrounded by double quotes
eg
"1234
5678"

not

1234
5678
 
Back
Top