Can anyone tell me if it's possible to change a columns contents in Excel. All I want is the cabinet number not this ('(Cabinet No.1) starter/ 35Lumg-MOD1 108"H X 32 3/4"W X 24"D (Base)). Does this make sense?
Ron
Sorting cutlist in Excel
Moderators: Jason Susnjara, Larry Epplin, Clint Buechlein, Scott G Vaal
-
- Junior Member
- Posts: 48
- Joined: Tue, Jan 08 2008, 8:04PM
- Location: Louisville, GA
-
- Junior Member
- Posts: 73
- Joined: Thu, Nov 17 2005, 8:19PM
- Location: Calgary, Alberta, Canada
Re: Sorting cutlist in Excel
Ron
Select the first column where the info starts. Then select Data, text to columns, then follow instructions. Excel will automatically set up breaks in the info essentially dividing the info into new columns. You can then double click on the lines to remove or add new columns. Once this is done you can delete columns you don't want. When I do this I end up with two columns, one that i don't want and one with the info I want to keep. You can set the columns up however you wish. just one more thing, sometimes when expanding cells to expose more info the rows go wonky. To fix this you have to select all the rows, select format, cells, align to top, then format, row, height and change height to 15.
Hope this makes sense.
Select the first column where the info starts. Then select Data, text to columns, then follow instructions. Excel will automatically set up breaks in the info essentially dividing the info into new columns. You can then double click on the lines to remove or add new columns. Once this is done you can delete columns you don't want. When I do this I end up with two columns, one that i don't want and one with the info I want to keep. You can set the columns up however you wish. just one more thing, sometimes when expanding cells to expose more info the rows go wonky. To fix this you have to select all the rows, select format, cells, align to top, then format, row, height and change height to 15.
Hope this makes sense.
Rob Frenette
_______________
Calmark Cabinetry & Woodwork Ltd
Specializing in CNC Machining & Edgebanding
_______________
Calmark Cabinetry & Woodwork Ltd
Specializing in CNC Machining & Edgebanding
-
- Junior Member
- Posts: 48
- Joined: Tue, Jan 08 2008, 8:04PM
- Location: Louisville, GA
Re: Sorting cutlist in Excel
Rob,
PERFECT! Thanks a lot!
Ron
PERFECT! Thanks a lot!
Ron
-
- eCabinets Beta Tester
- Posts: 1740
- Joined: Tue, May 17 2005, 8:33PM
- Company Name: Timeless Cabinetry and Mantles
- Location: South East
Re: Sorting cutlist in Excel
Ron,
Once you have perfected this save this as a macro and you can run the macro and it will sort through the spread sheets automatically.
Mike
Once you have perfected this save this as a macro and you can run the macro and it will sort through the spread sheets automatically.
Mike
Intel Core i7-5820K (6-Cores, 3.3GHz, 15MB Cache)
32Gigs DDR4
NVIDIA GeForce GTX 960 4GB
SSD 840 256Gig, 2TB, 3TB, Samsung (2TB)
Corsair RM650
32Gigs DDR4
NVIDIA GeForce GTX 960 4GB
SSD 840 256Gig, 2TB, 3TB, Samsung (2TB)
Corsair RM650