muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all..
how to extract data below (contains mark etc.)
my target in cell L4 down and as number not text
any help would greatly appreciated..
.sst
how to extract data below (contains mark etc.)
Book1 | ||||
---|---|---|---|---|
K | L | |||
3 | data (text) | target (number) | ||
4 | = 1.812,00 m3 x 610.383,00 /m3 x 0,840 | 1,812.00 | ||
5 | = 579,00 m3 x 610.383,00 /m3 x 0,840 | 579.00 | ||
6 | = 20,00 m3 x 610.383,00 /m3 x 0,840 | 20.00 | ||
7 | = 24.500,00 m3 x 610.383,00 /m3 x 0,840 | 24,500.00 | ||
8 | = 356.500,00 m3 x 610.383,00 /m3 x 0,840 | 356,500.00 | ||
9 | = 1.750.500,00 m3 x 610.383,00 /m3 x 0,840 | 1,750,500.00 | ||
Sheet1 |
my target in cell L4 down and as number not text
any help would greatly appreciated..
.sst