I have an Excel sheet which has a Text column Name Object Name. Now I have another script which using these columns further processing. Now before running the script with it, I want to trimmed out some characters from the object name column values.
Values in that column has carrying length of characters,but I want all of them to be 15 characters only, whichever values having the length more than 15 characters must be trimmed out. Is there any function in Excel 2010 by which I can do such activity within few minutes.