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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top