Well, if you're going to get weird with the data like that, I'll go for the VBA answer so the formula is at least readable. Here's a new function called SQFT() you can add to your workbook to make this easy:
==========
How to install the User Defined Function:
1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet
===========
How to use the new function.
If the text strings are in column A, put this formula in an adjacent cell as shown:
You didn't show any spaces in the sample, but adding them won't hurt anything.
Bookmarks