Help Needed...

B

BB

I have a cell that contains the following info, 32°19' 786N-108°33' 627W.
Is there a formula that will remove partial data from a cell. For example,
I need to remove everything after the N. Any help would be appreciated
 
J

JE McGimpsey

See answer in worksheet.functions.

Please don't post the same message in multiple groups. It only fragments
your answers and potentially wastes the time of those replying to posts
that have already been answered.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed... 8
Need Help with a VBA subroutine 0
You'll need a new app to open this about link 1
Trying to figure the formula 1
Excel - Wich Function should I use? 1
Office Word JPEG in a document showing but not printing out 0
Summing up rows that only have all the values 3
Need help with an IF Function 4

Top