Help Needed...

  • Thread starter Thread starter BB
  • Start date Start date
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
 
See answers in worksheet.functions.

Please don't post the same message in different groups - it just
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
 
=Left(B3,11) will provide the result 32°19' 786N, Where B3 is the cell
containing the original data. Hope this gets you started.
 
Back
Top