Text being generated based on other text entered

[zimjason_1]

Hi all,

Ill start off by example of how i would do what i want to in excel.

Cell A1 = "1+"

Cell A2 = "PR"

Cell A3 =  "1"

Cell A4 = "1"

Cell A5 = "Black

To achieve the result i would do the following formula

=A1&" / "&A2&A3&" - "&A4&" = "&A5

Give this result 

1+ / PR1 - 1 = Black

in the drawing below i have a similar thing i want to use 

1+, B1, SH and then reference text in another drawing to complete.

and do a similar thing at the bottom but the text is all drawing.

Please see snip in attachments of completed file and hopfully it makes sense of what i am trying to achieve.

[james.mcmillanNYR6A]

I can't tell exactly what your trying to do, is it the terminal annotation?

There is help here on replaceable parameters that could be of use.

https://help.autodesk.com/view/ACAD_E/2022/ENU/?guid=GUID-8F803D63-4390-4617-BC71-F68AE7545D97

[zimjason_1]

Hi Sorry maybe i wasnt to clear,

I have an excel sheet which contains the Junction Box number all the core idents, cable idents, terminal numbers & Equipment Tags, i am after a way to link this into the M text in the DWG file so i can change the excel tag as the junction box layout and terminals are the same so its just the core idents cable idents equipment tags that will change and the drawing number and junction box rather than change 20-30 m text copy and paste was wondering if there is a way just to change the source cell in the original excel then update the drawing?

Hope these drawings will make more sense?

[james.mcmillanNYR6A]

There are ways to get information between excel and your dwg, though not I think exactly as your are describing. If the Mtext is flat text that you have put in there will not be a direct method out of the box.

You should look at the export to spreadsheet tool, attributes will be exported, you can change them and reimport. 

If there is some intelligence behind the Mtext you might be able to work with that.