Get instant live Excel expert help with Text Functions

How to highlight, in colour, part of a text in a cell

Changing quantitative values into text (created separate text sheet which was melded with data sheet using IF formula into 3rd sheet that now includes 0 values as well as transformed text. Now I need to remove all zeros to sum columns into one text result. Need to make the zero removal automatic going forward. If there was a way to use IF formulas to substitute text for numbers without creating 0's for those columns that didn't have a corresponding number value, that would be ideal. Can you help?

I need to formula to test my data. I am looking for duplicates with two conditions: ord instant (time) (column A) AND ord erx id (column c). The ord instant for a drug and ord erx CANNOT occur at the same time therefore it is a duplicate. Also I do not have access to google docs, I would need an explanation in the text box. Thank you

I have a multi-sheet pivot table, and I am looking to find a way for excel convert number to text

I'm having trouble with vlookup two values. I need help to fix a logic check formula to compare two values, but pull one as text *1 to take formatting into account. I'm attempting '=IF(INDEX(TEXT(A16,"0"))*1)=(INDEX(C16)),"CORRECT","FAIL" but a VLOOKUP might work as effectively Relates to a significant excel bug - see sheet

I need a macro to find each row with text and insert two new blank rows above it

I have a column that was created in general text, but is in numerial order. I wants numbers that appear such as 455 456A 456B 456B1 to appear in an order of low to high to numbers, including text

Hi, I'm trying to dynamically link a cell (specifically a column header) in Table B to a column header cell in Table A on another worksheet in Excel. I'm using structured referencing which is returning '0' as text when I complete the formula (and the formula disappears). I've tried both typing the formula and creating it by typing = and clicking on the cell I want to link to. If the title of the column header in Table A changes, I need that change to be reflected in the relevant column header in Table B too. I've been searching forums for the solution but haven't found it yet!

I am formatting a column of number/letters to be stored as text. A formula relies on a vlookup with this column being used as the first criteria. It should work fine however I must go into each cell in the column, hit F2, then hit enter for the formula to identify it is stored as text. Is there an easier way to do this for the entire column since it is thousands of cells?

I would like to have this excel sheet with no gaps and saved in text file