Hi i have a spreadsheet that is full of coordinates. I need the DEG MM.DDD in one cell. Tight now DEG is by itself and then the MM.DDD is in the adjacent cell. What formula can i use to have this put into one cell?
i have attached my spreadsheet and really appreaciate any help.
Stew
Whatever is between the quotes will act as a separator:
Cheers,
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
you cant format the cell to this! but if you want to combine for display purposes only :-
=D2&TEXT(E2," 0.000")
or you can do this if you want x.xxxx
=D2+(E2/60*SIGN(D2))
this may also help :-http://www.cpearson.com/excel/LatLong.aspx
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
duplicate post
Worked Great! thank you!Originally Posted by ConneXionLost
Whatever is between the quotes will act as a separator:
Cheers,Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks