Is there a way to remove the ' before each # in the cutlist so the number can be recognized? Replace will not find a match for it. I can remove manually - but that is time consuming!!
Thanks
geting rid of the ' sign in the cutlist
Moderators: Jason Susnjara, Larry Epplin, Clint Buechlein, Scott G Vaal
-
- Senior Member
- Posts: 199
- Joined: Sat, Jul 29 2006, 9:11AM
- Company Name: Classic Custom Wood
- Location: NC Iowa
- Contact:
-
- Wizard Member
- Posts: 1896
- Joined: Wed, May 18 2005, 7:54PM
- Company Name: Milltech Millworks Ltd.
- Country: CANADA
- Location: Edmonton, Alberta
- Contact:
Re: geting rid of the ' sign in the cutlist
Hi Ray, I will assume you mean while in Excel, in Sheet Component Listing hilite the whole column (ie column E for width) then click Edit>Find. There you can enter " in the Find What box, then click Replace. In the Replace With box don't enter anything, click Replace All. That will remove all the inch markers from that column. From there you can hilite all the numbers in that column and convert them to a number all at once. HTH
-
- Senior Member
- Posts: 199
- Joined: Sat, Jul 29 2006, 9:11AM
- Company Name: Classic Custom Wood
- Location: NC Iowa
- Contact:
-
- Wizard Member
- Posts: 4722
- Joined: Mon, May 09 2005, 7:33PM
- Company Name: Double E Cabinets
- Country: UNITED STATES
- Location: Amarillo, TX
Re: geting rid of the ' sign in the cutlist
Ray,
After removing the " marks the numbers are entered as text so you will have to convert them to numbers.
Kerry
After removing the " marks the numbers are entered as text so you will have to convert them to numbers.
Kerry
-
- Senior Member
- Posts: 199
- Joined: Sat, Jul 29 2006, 9:11AM
- Company Name: Classic Custom Wood
- Location: NC Iowa
- Contact:
Re: geting rid of the ' sign in the cutlist
Yea, found that out and how to do. My world is much better now. Thanks