| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I want a formula to ignore text eg 5mts * 5 ignoring the mts any .
any help to the above would be appreciated
|
|
#2
|
|||
|
|||
|
Two ways for the example posted:
You could try something like this: =LEFT(I11,1)*I12 If 5mts is in I11 and 5 is in I12 You may also want to consider using a Custom Number format that would put the mts into the cell instead of typing it manually. Something like: General"mts" tj "Malshenton" wrote: any help to the above would be appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Formula to average ignoring negatives? | Excel Discussion (Misc queries) | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
| Using color to ignore cells in a formula????? | Excel Discussion (Misc queries) | |||
Linear Mode
