SqFt Calculation from L" x W" in one column

Good Morning,

I have a spreadsheet that I inherited to manipulate. Without completely reconfiguring the spreadsheet, I need to calculate the SqFt of the values in cell E4 to be placed in cell F4. I know this would be easier if the values were in their own individual cells, but again, this is how I inherited it. Currently it is formatted 50" x 50" in E4. This is going to be later used to calculate a monthly rate in L4 based off based of (F4 times G4) times my monthly rate per SqFt. I've searched the threads and found previous suggestions and attempted those, but was unable to make them work. HELP PLEASE!!!! Thank you in advance.

Screenshot 2022-04-19 080735.png

Try

=LEFT(SUBSTITUTE(E2,"""",""),2)*RIGHT(SUBSTITUTE(E2,"""",""),2)/144

If dimensions are 3 figures then highlighted need to be changed

Try:

=--LEFT(SUBSTITUTE(E2,"""",""),2)*--RIGHT(SUBSTITUTE(E2,"""",""),2)/144

If that doesn't work, attach a sample workbook for us to troubleshoot |(not a picture of it).

See attached

See yellow banner at top of the page (threads).

And please update your Excel version: Windows 10 is NOT an Excel version!

Try

=LEFT(TRIM(SUBSTITUTE(E4,"""","")),2)*RIGHT(TRIM(SUBSTITUTE(E4,"""","")),2)/144