Text Strings

Copper Contributor

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""]"