One can do it in two ways I guess
1. Export the file in Access and delimeter being "-" abd then convert this
to .tab format.
2. Save as text and then convert back to Excel with delimeter "-".
This should solve the problem
Sunil
On Wed, 15 Sep 1999, Ryan Richter wrote:
> I was given an excel spreadsheet that contained around 300 co-ordinates that
> I need to plot in MapInfo...Problem, the co-ordinates for both latitude and
> longitude are all in the same cell, separated by a "-". eg. 40-30-41, and
> the cell format is just general. If anyone has a quick solution to either
> separate these numbers into three separate columns (then I can easily
> convert them into degrees, minutes, seconds), or even better, if someone has
> devised a program that will work in MapInfo to convert a column in this
> crummy format to decimal degrees I would love to hear about it ASAP.
>
> I have downloaded many of the extra MapBasic utilities on this website and
> found many of them extremely useful. If one of these will do that and I
> just haven't found it or figured it out please let me know.
>
> Thanks to anyone who can solve this relatively simple, yet pain in the butt
> problem.
>
> Ryan
>
>
> -------------------------------------------------------------------
> Ryan Richter
> GIS Specialist
> DC - Development Consultants
> [EMAIL PROTECTED]
> (215) 348-4239 ext. 110
> Fax - (215) 348-4997
> -------------------------------------------------------------------
> Suite 312 Penn's Court
> 350 South Main St.
> Doylestown, PA
> 18901
> -------------------------------------------------------------------
>
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
