Not what you want. But a 3:d cheating version Put numbers in column A =ROW() and use the number-format "00#" at least 2 rows of Exemple data in B Select B1:B9 press Ctrl+E for excels "intelligent" Flash Fill Deleted just a suggestion Nikolino I know I don't know anything (So...
Excel incrementing Can someone please tell me how to increment by 1 the numbers only when you have letters with the numbers? For example: I have B-001A and need to increment the 001 by 1, so that when I drag it down I get B-002A, B-003A, etc. I know how to do it with jus...
All MonthNames and Month numbers in sql server All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists. all the events in the workload were ignored due to syntax errors.the most common reason for the error would be data...
Compare 2 files and get line numbers Compare acl Compare creation dates of two files in Powershell Compare CSV and make it a chart using powershell Compare Home Folders to AD accounts Compare list of specific users to AD via Powershell Compare multidimensional arrays Compare timestamps for two ...
Put numbers in column A =ROW() and use the number-format "00#" at least 2 rows of Exemple data in B Select B1:B9 press Ctrl+E for excels "intelligent" Flash Fill Deleted just a suggestion Nikolino I know I don't know anything (Socrates)...
Can someone please tell me how to increment by 1 the numbers only when you have letters with the numbers? For example: I have B-001A and need to increment the 001 by 1, so that when I drag it down I ... If you try this formula, you only have to adapt it to your needs or ...
Can someone please tell me how to increment by 1 the numbers only when you have letters with the numbers? For example: I have B-001A and need to increment the 001 by 1, so that when I drag it down I ... Chris405 If you try this formula, you only have to adapt it to your ne...