Excel IF function for text

B

BarnyardJoe

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?
 
F

Frank Kabel

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
 

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

Excel does not accept text format! 0
Excel - Wich Function should I use? 1
Formating bolded text exclusively. 0
Anything will help 0
Link a text box based on drop down box with four options MS Word 365 0
Paste to excel from word - auto format problem 1
Merging from an Excel file with graphics 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0

Top