alex0182828
Board Regular
- Joined
- Jun 20, 2012
- Messages
- 88
- Office Version
- 365
- Platform
- MacOS
I need remove string starting in a number and ending in 'cm' or 'CM' and replace with a # symbol.
Number can be anything and the string between the first number and the cm can be or variable length.
There will only be one occurance of this pattern in each cell.
Made example table can anyone help ? Thanks
Number can be anything and the string between the first number and the cm can be or variable length.
There will only be one occurance of this pattern in each cell.
Made example table can anyone help ? Thanks
Book8 | ||||
---|---|---|---|---|
A | B | |||
1 | Source | Result | ||
2 | Frog *** Halskette 34,5 - 56cm | Frog *** Halskette # | ||
3 | Rund Pavé - Fassung Nosiw 20,5 - 81cm | Rund Pavé - Fassung Nosiw # | ||
4 | adasd 85,5 - 91CM Fuchwanz Kette | adasd # Fuchwanz Kette | ||
5 | Rosoldet CAAAsf 35,5 - 71 cm Fuchsschwanz Kette | Rosoldet CAAAsf # Fuchsschwanz Kette | ||
Sheet1 |