Search for a specific character in a cell in an if statement

  • Thread starter Thread starter mcl
  • Start date Start date
M

mcl

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".
 
One way:

Assuming that your formats are all 00-00-00x (where x = S or N)

Choose Data/Text to Columns/Fixed. Click next. Click just to the left of
the N/S. Click Finish.
 
You must log in or register to reply here.

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

Searching for an additional item via an IF statement 5
Scrabble Value calculation for Welsh words 0
match formula 2
Two Level Search 1
Combining AND/OR in an IF statement 4
IF Statement with Dates & Calculations 5
putting a date in an if statement 5
Multiple IF statement 1

Back
Top