anglais428
Well-known Member
- Joined
- Nov 23, 2009
- Messages
- 634
- Office Version
- 2016
- Platform
- Windows
I am looking for a formula that will identify the position of the last letter in a cell, ignoring punctuation and special characters.
E.g. If the text in a cell is:
This,text,in,a,cell,,,,,,
The result should be 19 as the last "L" is in position 19. It should ignore all the commas at the end.
E.g. If the text in a cell is:
This,text,in,a,cell,,,,,,
The result should be 19 as the last "L" is in position 19. It should ignore all the commas at the end.