Custom Format
I would like to use a custom format that will take a number/text string like:
1405828AB
And convert it to:
140N-58W-28-AB
Where the N and W are fixed, but the "AB" can be any combination of two of
the following four letters A, B, C, D.
I have a version that works for everything but the letters at the end and it
is:
###"N"-##"W"-##-
but can't get the rest of it.
Your help is greatly appreciated...
Thanks,
J
|