SashaGorgov
New Member
- Joined
- Jun 1, 2021
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
Hello!
I have a bunch of data that is listed vertically as text in the following format: '£3.4M' or '£287K' and sometimes '£6.9M (£7.4M)' with the brackets denoting a revised sum.
I couldn't think of a way to convert this to numbers so I can perform numerical analysis, just wondering if anyone has any ideas?
I have a bunch of data that is listed vertically as text in the following format: '£3.4M' or '£287K' and sometimes '£6.9M (£7.4M)' with the brackets denoting a revised sum.
I couldn't think of a way to convert this to numbers so I can perform numerical analysis, just wondering if anyone has any ideas?