OK, if I have a column of latitudes (for example) in this format 29-34-10N
where it's degrees minutes and seconds. I want to pull the N (or S) out and
put in in a new column. I could then just do a search and replace to remove
all the N's of S's from the original column. How could I set up an "if" to
do that? I assume it would look something like this: =if(search for
N,"N","S"). How or can I do the "search".