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
 
Top