Get instant live Excel expert help with Text Functions

I am looking to export part of an excel spreadsheet: only those lines that have some text in Column N. How do I do that please?

Hi...I'm having trouble adding a column of cells that contain an IF TEXT formula. For instance, each cell equates to 8 + 8 + 7 + 4 + 8 = 35...what is the SUM formula to add these...the normal =SUM comes to 0...

I am trying to sum a value in column "C" if the cell in column "B" matches the text I am looking for, and do this over 50 rows. I can do it one row at a time, and that is working - it would just make my argument so long. Here's what I have that is working (3 rows worth): =(IF(A2='Monday 11-13'!B2,'Monday 11-13'!C2,0)+IF(A2='Monday 11-13'!B3,'Monday 11-13'!C3,0)+IF(A2='Monday 11-13'!B4,'Monday 11-13'!C4,0)) (Monday is the name of the worksheet where the data are)

Hi I am trying to add two cells, only if a third cell contains certain text

Hi, I'm looking to create a from by typing in the reg and it pulling through the data from the data tab. I've tried this as a VLookup but it only pulls through the first line and there may be more than one line under each reg for repair history. I tried doing this as a pivot table, but I don't like the layout of it and wanted to be able to type in a reg and it search for the data rather than filtering. I've tried a combination of both by creating a macro to copy the data from cell A1, refresh the data in the pivot table, filtering by pasting the results from A1 then copying the relevant data I require onto the form tab. It works, but when I change the reg it remembers the actual reg text from the macro rather than the act of copying and pasting the data in A1 from the form. Can you help me please?

I'd like find the macro code that will let me check each row of a column for multiple text strings. If it matches a particular text string it will add the corresponding text in the same row but in the next column. For example: If the text in F2 = "Group A" then put the word "Vocabulary" in G2. If the text in F2 = "Group B" then put the word "Watch" in G2 I need it to go through 22 possible text strings for each row in column F. There's also a possibility that there will be no text in the F column. In which case nothing gets put in the G column. What do you think? Can you help me out? I appreciate it!

I'd like find the macro code that will let me check each row of one column for multiple text strings. If it matches a particular text string it will add the corresponding text in the same row but in the next column. For example: If the text in F2 = "Group A" then put the word "Vocabulary" in G2. If the text in F2 = "Group B" then put the word "Watch" in G2 There's also a possibility that there will be no text in the F column. In which case nothing gets put in the G column. I just need the basic set up. I can put in the column and row details and copy and paste the if/then statements for each text string combination. Thanks!

i want to do an index, match search. one of the criteria i want to match is a date which is formatted as MMM-YY (Worksheet "Index Returns" Cell $C$1) against a column of dates formatted as 1/01/2017 (Worksheet "BSG_Subj_RTN" Cell $A$266). If the formatting were reversed, I would simply take my numeric date and translate it to a 'text'... but I do not seem to be able to take a column of numeric dates and covert them to a text. What do you recommend?

Spreadsheet attached: I want to use Index, Match to find the appropriate benchmark values for a given date. My problem is that the date I am searching for is formatted as: MMM-YY and the column I need to search is formatted: 01/01/2017. The spreadsheet I am working with is attached. the first worksheet ("Index Returns") I am trying to fill with values from BSG_Subj_Rtn. If the formats were reversed I could search using Text ...but this does not seem to work when searching an entire column. Any thoughts would be very much appreciated.

I need help taking the text under my charts and making it centered under the graph and visible throughout the full length of the question.