I have a vendors spreadsheet that has a length in feet (Ft.) in cell A1. This data is on every worksheet for as many cables as there are. (i.e. sheet 1 A1 100 Ft. , sheet 2 A1 200 Ft. , sheet 3 A1 300 Ft. - every number is followed by a space then "Ft.")
The total should be 600 Ft.
How would you total with text in the same cell? It should go to sheet 1000 A1
If A1 has only text or blank between 1-1000 it would not effect the total sum.
Thanks in advance