Excel IF function for text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to separate city, state, zip from 1 cell to 3 by using the IF
function. But I cannot get the IF function to recognize text values, only
numeric. I have already changed the cells format to text, but to no avail.
Any suggestions? Can it be done in excel?
 
Hi
not really sure what you're trying to do but have a look at 'Data - Text to
columns' for this.
Also you may post:
- an example
- your tried formulas
 
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

Need VLOOKUP to Work Two Ways 0
IF Functions for Text in Excel 2000 2
If logical function with text and numbers 7
search for text "beginning with" "containing" wildcards 1
Set non-continuous PrintArea via Function / Name 0
Excel VBA 1
#value! error in sum function 8
search function using wildcard 3

Back
Top