Forum Discussion
Limit characters in a column
I have a spread sheet from a client that needs editing for import into a EPOS system. Can cut and paste all information into the correct import format .csv other than the product descriptions, many ...
Hi John,
To truncate texts in column D to 25 characters
- insert new empty column to the right of column D
- select entire column D
- in ribbon Data->Text to Columns
- on first step select Fixed Width; on second one click on 25 mark in scale
and Finish
- delete the column which you added to the right of D with extra characters in it