Thanks for you help, once again.
The formula you've listed above helps me understand the worksheet syntax a bit better. However, I can't seem to get it to work for me. I guess I should mention I'm currently using 2008, in case this is a function that doesn't work in my version.
I tried simplifying it, ie remove the text, so that the hopeful result would be "2600 3000" just to see if I could get that working right but was not successful.
I used =CONCAT(WIDTH(C='Carpet'),' ',HEIGHT(C='Carpet'))
since the item I'm trying to get these values for is currently the only item on this class
I know I'm almost there, but apparently some small hangup is holding me back.