If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Custom Format
You can format numbers--not text.
Maybe you could use two columns--one for your entry and one to hold a formula that formats the entry nicely. =text(left(a1,7),"000\N\-00\W\-00\-")&right(a1,2) And you'd type the entry in A1 like: 01234567AB J wrote: 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 -- Dave Peterson |
#3
|
|||
|
|||
Custom Format
Thanks!
J "Dave Peterson" wrote: You can format numbers--not text. Maybe you could use two columns--one for your entry and one to hold a formula that formats the entry nicely. =text(left(a1,7),"000\N\-00\W\-00\-")&right(a1,2) And you'd type the entry in A1 like: 01234567AB J wrote: 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 -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|