Happy new year everyone.
I have a macro that saves selected columns from a Sheet to a new Workbook and save it as Text file.
Now I want to create an option to shorten to a number of characters in all the cells. For example: users will enter a number, that number is a number of characters that all the cells can have maximum. If they enter 50, all the cells that have more than 50 characters will be cut at the 50th character and add some dots after that. If nothing entered, all the cells will still show full length.
Any help would be appreciated.
Thank you very much.
Bookmarks