Hello everyone.
I have a series of cells (more than 800) placed with this text:
00123456789-FFF
00123456788-FFF
00123456787
00123456777-FFF
00123456999-FFF
00123455555-FFF
00123456444
I have to remove all the final -FFF
I tried but then replace the text becomes
123456789
123456788
00123456787
123456777
123456999
123455555
00123456444
the text should remain the initial 00 well:
00123456789
00123456788
00123456787
00123456777
00123456999
00123455555
00123456444
a help?
Thank you in advance.
max max
Bookmarks