Most RecentMost ViewedMost LikesTransformation of values' lenght in a field based on the number of caracters Hello, I would like to add a new field by applying a condition on data values from my Vendor field. I want to set each values in that field so they all have 10 characters and to do so i want to apply a condition in such a way that if the value's lenght is smaller than 10 then 0 should be added in front of the value until it makes 10 characters. For Example: Vendor 0045676 000034567 76890650 2340987653 I should get the following results: Vendor 0000045676 0000034567 0076890650 2340987653 Thanks for your help. Regards, Tatiana SolvedInserting New Columns of Empty Space between Pre-existing Columns Hello, I have an excel spreadsheet with about 50 columns and I want to insert new columns of empty space around every 5 columns (5th, 10th, 15th...). How would I go about doing that? excel formula I have an excel formula that is working in one spreadsheet but not in another. In the 082018 tab the formula is working but not in the 052018 tab. The formula's are in Columns E-O.
