Thread: Custom Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
j j is offline
external usenet poster
 
Posts: 128
Default 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