update text of a block connected to a cell excel

[bicok]

Hello, everyone! :
is the first question I ask, as well as the first post (beyond the presentation) I write... so I try to express myself to the best... counting on your experience to understand the same

already summarize the problem in the title was not easy, now I explain it well, step by step:

problem: I have blocks on an autocad sheet containing labels (e.g. ftc1617 (photocell) ) and I have to create a link of these labels to an excel sheet in such a way that, if on the excel table, I modify the ftc1617 label in ftc161616, after saving and updating, I find the block with the updated label

solution: let's say that I just miss a small step to make sure that it works totally, if the cell contains a number, the block updates, vice versa, if I insert a word, es " hello ", it gives me error, returning to the block "# "

procedure
-I select and copy the table from excel
- on autocad I do "special glue" - "connect glue" - "export as cad" [o nome simile]-I change a data on the excel table, except, I go on autocad, I do "upstream link" and it's all working
in the next step however I block
-double click on block text, right click, enter data field, formula, cell, select table cell in autocad and confirm by pressing ok
:finger: if: in the cell there is a number, it returns it to the block. if I change the number in the table, then report the new value in the block. So the result that I wanted to achieve was... If it wasn't that I don't have to enter numbers... but, alphanumeric codes. . in fact:
If :angry: instead: in the cell there is text of only letters or alphanumeric, it reports in the block "# " ...
I ask you If you can tell me how to connect block text to cell, so you bring anything is contained in the cell, so also an alphanumeric code (since it is only photocells ftc1617 etc etc etc etc etc.)

Thank you so much! :

 

[dieva]

fields connected to the cells of a table in autocad are always numerical type... not at all found in the formula section (something to calculate. . as well as other media buttons, count and sum).

If your acronyms always have the same prefix and only change the numerical part you could do so:
1) to maintain the integrity of the excel sheet creates another column somewhere in the excel sheet in which you extract the numerical part of the acronym.
use this formula =stringa.estrai(a2;4;4) where a2 is the cell that connects the alphanumeric acronym.

2) the cells of this new column will be the ones you have to point to, then paste the selected table and create the table in autocad as you have already done.

3) create fields that point to the numerical cells and, when you define the fields, through the button
'additional format' add the theme "ftc" as a prefix.

 

[bicok]

Thank you. a similar idea I had had as well: to make in excel the column with only the numerical value and to connect it just as you did... or to write "ftc- enter data field" since besides the link it also made me write before and or after

that this job is that I have to do it for a firm where I am doing internship... and so I will propose to them if the solution can love him well, datp that the problem is that.... ftc is not the only theme.... there are many more

If there was a way to connect the alphanumeric cell without passing through the string... would be woo

If you have other solutions... I am ready to read them. I thank you because you have found a good pseudosolution (which may be optimal)

other users besides saying that they have proposals for my post?? ?

thanks and good evening