AlWilcox
New Member
- Joined
- Jan 29, 2025
- Messages
- 6
- Office Version
- 2013
- Prefer Not To Say
- Platform
- Windows
Hello,
I'm trying to extract a numeric value from the end a text string as follows:
I can get the date out (1st 6 characters) and I can get the text in the middle, but I'm having issues getting the numeric data from the right side of the string (128.72). The number could be positive or negative, and I wish to retain that.
Any ideas how to proceed here?
Thanks
I'm trying to extract a numeric value from the end a text string as follows:
01/03 PURCHASE INTEREST CHARGE 128.72 |
I can get the date out (1st 6 characters) and I can get the text in the middle, but I'm having issues getting the numeric data from the right side of the string (128.72). The number could be positive or negative, and I wish to retain that.
Any ideas how to proceed here?
Thanks
Last edited by a moderator: