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...
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...
How to change format of phone numbers in PowerShell? How to change input keyboard language in powershell How to change IP address settings and computer name by Powershell How to change language in Powershell (to english)? how to change powershell languagemode to FullLanguage How to change th...
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 just numbers, very easy but need help when there are letters involved. Thanks excel Formulas and Functions kudo count Reply 4 Repl...