I am exporting a simple report from Autodesk Revit that has (100 SF) I the same cell. how do I get rid of the SF from the cell or make excel understand it is Square footage.
I am exporting a simple report from Autodesk Revit that has (100 SF) I the same cell. how do I get rid of the SF from the cell or make excel understand it is Square footage.
Last edited by Dufster; 08-28-2017 at 12:48 PM.
b1 = left($a1,3)*1 returns 100
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks