="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
If you are experiencing a similar issue, please ask a related question
Title | # Comments | Views | Activity |
---|---|---|---|
text replacement instead of two macros only one macro | 2 | 19 | |
InStr Function not working properly in macro | 3 | 19 | |
Conditional Format - Prevent User entering USA Date formats into Excel 2010 | 3 | 22 | |
Merging-Splitting-Multiple |
33 | 42 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
24 Experts available now in Live!