I have a col in a sheet that has an extra char that I need to remove for 400 rows.
The char is a "N" and is at the end of every row in col A. There is also space in between of what I want to keep. There is not set number of spaces in between what I want to keep and the "N". There are different begining words within the 400 rows.
Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!
A little background as to how I came to I design this code:
Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…