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 |
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 |
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 |
All times are GMT +1. The time now is 07:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com