Jon_London
New Member
- Joined
- Jan 24, 2019
- Messages
- 12
- Office Version
- 365
Hi everyone
I have a requirement to remove the final comma and any text after it in a spreadsheet (example image below):
So, in the example I would like to remove ,SomethingOrOther on the second row then ,ThisAndThat on the third row and so on. The text after the final comma can vary quite a lot, so a simple replace wouldn't really work.
Does anyone know a way to do this please? We have a huge spreadsheet and have to manually remove this data each month.
Many thanks
Jon
I have a requirement to remove the final comma and any text after it in a spreadsheet (example image below):
So, in the example I would like to remove ,SomethingOrOther on the second row then ,ThisAndThat on the third row and so on. The text after the final comma can vary quite a lot, so a simple replace wouldn't really work.
Does anyone know a way to do this please? We have a huge spreadsheet and have to manually remove this data each month.
Many thanks
Jon