Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Search for a specific character in a cell in an if statement
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". |
#2
|
|||
|
|||
Hi
try using 'Data - Text to columns' to separate your data -- Regards Frank Kabel Frankfurt, Germany "mcl" <marc.levine_at_no_spam_afccc.af.mil_no_spam schrieb im Newsbeitrag ... 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". |
#3
|
|||
|
|||
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. In article , "mcl" <marc.levine_at_no_spam_afccc.af.mil_no_spam wrote: 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". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) | |||
How do I insert an image into a specific cell within a protected . | Excel Discussion (Misc queries) | |||
Searching a cell for a certain character. | Excel Worksheet Functions | |||
VBA Command to Look at cell in an If statement | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |