Excel has totally 2500 rows.In this excel description column have some new line characters.

We are trying to load (From Excel to Table) description column having more number of new line characters (Around 50 lines) in a cell and it got failed with error string contains untranslatable character.

We have to set a character limit and remove characters over that limit in excel cell and load the data to table.

Note: To install kutools need admin permission.so its not possible.

Please let me know any other option is available to remove new line characters other than kutools.