Home

Text Strings

%3CLINGO-SUB%20id%3D%22lingo-sub-354262%22%20slang%3D%22en-US%22%3EText%20Strings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354262%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20create%20the%20following%20text%20string%3A%3C%2FP%3E%3CP%3E%5Btext%20name%3D%22%2CJ1%2C%22%20memo%3D%22%2CA1%2C%22%20size%3D%223%22%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20this%20in%20another%20program.%20There%20are%20about%20300%20lines%2C%20and%20all%20the%20data%20is%20already%20in%20a%20spreadsheet%20format.%20Cells%20J1%20%26amp%3B%20A1%20are%20the%20only%20references%2C%20everything%20else%20is%20constant.%3C%2FP%3E%3CP%3EJ1%3DLAB_1%3C%2FP%3E%3CP%3EA1%3DRBC%20(Male)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20my%20finished%26nbsp%3Bstring%20should%20look%20like%3A%3C%2FP%3E%3CP%3E%5Btext%20name%3D%22lab_1%22%20memo%3D%22RBC%20(Male)%22%20size%3D%223%22%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHelp%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-354262%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-354740%22%20slang%3D%22en-US%22%3ERe%3A%20Text%20Strings%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-354740%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3D%22%5Btext%20name%3D%22%22%22%26amp%3BJ1%26amp%3B%22%22%22%20memo%3D%22%22%22%26amp%3BA1%26amp%3B%22%22%22%20size%3D%22%223%22%22%5D%22%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Bryan_Broyles
Occasional Visitor

I need to create the following text string:

[text name=",J1," memo=",A1," size="3"]

 

I am using this in another program. There are about 300 lines, and all the data is already in a spreadsheet format. Cells J1 & A1 are the only references, everything else is constant.

J1=LAB_1

A1=RBC (Male)

 

So my finished string should look like:

[text name="lab_1" memo="RBC (Male)" size="3"]

 

Help?

1 Reply

That could be

="[text name="""&J1&""" memo="""&A1&""" size=""3""]"
Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies