="0" & LEFT(A2,2) & MID(A2,4,1) & TEXT(SUBSTITUTE(MID(A2,6,2
It is worth noting that your original data has a mix of spaces and non-breaking spaces. The formulas converts them all to regular spaces.
Dim a, b, c As Long 'Incorrect way: a and b are Variant; only c is Long
Dim a As Long, b As Long, c As Long 'Correct way: all three variables are Long
Title | # Comments | Views | Activity |
---|---|---|---|
Connect to a database from Excel using JDBC instead of ODBC | 3 | 32 | |
cannot get subtotal to work | 8 | 18 | |
Excel Spreadsheet in a Word 2016 document. | 3 | 35 | |
Excel 2016 Hiding Toolbars | 7 | 23 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!