In my input excel file I have a column that has long names with many characters but application input form doesn’t allows to enter text more than 40 characters.
So as an input I only want to use name cell column value with maximum of 40 characters.
Is there any specific excel or any other acivity I can use to remove characters from excel ? Or while using the text as an input before entering into application form? Or there are any other ways to achieve it?