Jump to content

Excel / Search and Replace


Kemphas

Recommended Posts

Is there any way to build for example a wire list in excel and insert it into ACDLT2010 where each cell would = a different text box that i can CTRL+X CTRL+V instead of manually typing each wire number at terminals?

 

Also is there any way to for example to select 10 text boxes and Search & Replace. Example i have two components that are identical, but named #1 and #2 or Unit A Unit B to search and Replace #1 with #2 instead of entering each text box changing the number than going to the next?

 

- Thanks.

Link to comment
Share on other sites

Your limited by LT maybe look at Autocad Electrical.

 

Part 1 using excel you can do programming stuff and paste it to Autocad command line and get it to draw stuff in LT.

 

Part 2 maybe FIND

Link to comment
Share on other sites

  • 3 weeks later...

 

BTW I use Excel for modbus lists' concatenating them and / sorting the large amounts of data it also helps in auto building and not typing descriptions out every time or CTRL+V

 

If you insert a Data Table with a wire list for example, highlight the table and type "Explode" This breaks the table and breaks all the cells into different text boxes which accomplishes what i was getting after.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...