insert leaders at the coordinate use the text and coordinates from an excel file

[Inspection2.resolution]

I'm trying to insert a bunch of leaders with text using easting and northings as x an y. I've tried the following formula:

=CONCATENATE("(command ",CHAR(34),"_MLEADER",CHAR(34)," ",CHAR(34),B4,",",C4,CHAR(34)," ",CHAR(34),D4,",",E4,CHAR(34)," ",CHAR(34),A4,CHAR(34),")")

but I keep getting 

Command: (command LISP command is not available.
Command: "_MLEADER" Unknown command ""_MLEADER"". Press F1 for help.
Command: "2.1,3.4" Unknown command "1,3.4"". Press F1 for help.
Command: "3.6,3.9" Unknown command "6,3.9"". Press F1 for help.
Command: "ID1")
Unknown command ""ID1")". Press F1 for help.

I'm not to experienced with AutoCAD so appreciate any help. Thanks. 

[Sea-Haven]

Worked for me.

You can do this direct from excel reading the cells. Yes requires code, happy to discuss further. This is Autocad controlling the excel range input and returns a list of cells.

[hosneyalaa]

hi

see this

https://forums.autodesk.com/t5/visual-lisp-autolisp-and-general/insert-the-leader-at-the-coordinate-...

[Inspection2.resolution]

Unfortunately I was using autocad lite at work, it worked perfectly on 2022 version. All sorted now and have just saved so much time!! 

[ВeekeeCZ]

In LT, you should be able to use a script. The syntax could look something like this

MLEADER 2.1,2.4 3.6,3.9 "ID1";

MLEADER 2.1,5.4 3.6,3.8 "ID2";

... but I don't know how to end the text editor... try to ask in LT forum.