|
|
#19
12-14-2017, 08:49 AM
|
|||
|
|||
Attach your workbook. Change numbers but not the formatting etc.
In an empty column to the right in the first cell, put "=Len(A1)" Drag formula 4 columns to the right and however many rows you have in Columns A to D All numbers should correspond to the amount you need it to be. 14 For Columns A, B and C and 12 For Column D 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 VBA: Delete duplicates in each row
|
bandaanders | Excel Programming | 2 | 09-02-2015 08:15 AM |
|
Excel vba to check to check if two columns are empty
|
subspace3 | Excel Programming | 5 | 07-09-2015 04:45 PM |
| Macro to keep first instance and remove duplicates in certain column | zhead | Excel | 2 | 03-18-2015 10:16 AM |
|
find and delete duplicates
|
rcVBA | Word VBA | 4 | 05-15-2013 03:08 PM |
|
Deleting Duplicates in Macro
|
jillapass | Excel Programming | 1 | 01-11-2012 10:02 AM |
Windows 10 
Office 2013
Threaded Mode