coolzsters
New Member
- Joined
- Jul 23, 2018
- Messages
- 13
Hi all Master,
I'm really confused to grab TEXT from words, i already trying used many formula but still
<tbody>
</tbody>
<tbody>
</tbody>
i used below formula for calculate in No.4 but "SITE NO. 12345" always include
<tbody>
</tbody>
I'm really confused to grab TEXT from words, i already trying used many formula but still
No. | EXAMPLE OF DATA | |
1 |
<tbody> </tbody> | |
2 |
<tbody> </tbody> | |
3 |
<tbody> </tbody> | |
4 |
<tbody> </tbody> |
<tbody>
</tbody>
<tbody>
</tbody>
i used below formula for calculate in No.4 but "SITE NO. 12345" always include
FORMULA =TRIM(MID($C$6,FIND("-",$C$6)+1,FIND("}",$C$6,FIND("-",$C$6))-FIND("-",$C$6)-1))
<tbody> </tbody> |
<tbody>
</tbody>