macjagger17
New Member
- Joined
- Jan 25, 2022
- Messages
- 6
- Office Version
- 2016
- 2013
- 2010
- Platform
- Windows
Dear All,
Appreciate your assistance to my inquiry below. I wanted to extract the highlighted decimal number (put in Column B) from the text string cell (Column A) as below. Anyone can assist on the formula?
Source - text string cell in Column A
The decimal numbers I want in Column B
Appreciate your assistance to my inquiry below. I wanted to extract the highlighted decimal number (put in Column B) from the text string cell (Column A) as below. Anyone can assist on the formula?
Source - text string cell in Column A
1/11/21 960 C P GL 71,959.26 71,959.26 CR |
24/01/22 10 D A CC 10.90 348.46 CR |
2/12/21 60 C A CC 70,076.00 320.50 DR |
24/01/22 10 D A CC 417.50 1,445.46 DR |
1/11/21 960 C P GL 71,959.26 1,143,461.42 CR |
The decimal numbers I want in Column B
71,959.26 |
348.46 |
320.50 |
1,445.46 |
1,143,461.42 |