# Get instant live Excel expert help with Text Functions

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I am uploading stock index performance data by month from an inflexible data base. The months are represented by text...i.e.,, "Sep-17". My Fund Performance data is uploaded as "current month" and only further identified by a second column containing the date, i.e., 9/30/2017. I need to be able to somehow match the 9/30/2017 to the "Sep-17". Any thoughts?
Solved by X. W. in 18 mins
Count how many cells used in a column with text inside them instead of numbers (like value or count but with no numbers involved)
Solved by O. J. in 29 mins
I need to conditionally format an excel sheet so that the following occurs: If a cell contains "TEXT A", then the cell 5 columns to the right will populate "TEXT B".
Solved by D. S. in 16 mins
I have a list of objects + information and a table whit input cells. I want a formula (?with the If function?) that determines if the entered text in the input cell matches one in the list of objects and in return fils the columns with the same information.
Solved by O. L. in 27 mins
In the Eligible for Bonus column, enter a formula with IF and OR functions to display the text no if the employee's pay grade is D or the employee's job status is a part time (PT). Leave the cell blank if the employee is eligible for a bonus
Solved by D. W. in 30 mins
Hi, I am trying to get this text string which actually is a US date and time into a UK date format i.e. 10/29/2017 00:00:00 GMT to a date format of dd/mm/yyyy
Solved by I. B. in 12 mins
I am looking for a function that will look in a range of cells for specific text, and anywhere that text takes place I want to add the number next to that cell. for example if apple is mentioned 4 times in a series and the numbers 3,6,2, and 2 appear next to each of them respectfully, I want the formula to return 13
Solved by E. J. in 16 mins
How do you autofill cells with text and numbers?
Solved by M. E. in 23 mins
I understand how to reference a cell from another spreadsheet by typing =, selecting the spreadsheet, and then clicking on the appropriate cell. The value from the selected cell then appears. Should look something like this: ='Vision Trends Pricelist'!H2 I'm trying to create that string by coming three different cells: First Cell: 'Vision Trends Pricelist'! Second Cell: H Third Cell: 2 I"m able to coming the text string as it should; however, it shows the actual text. I want the formula to execute and actually display the information from the Vision Trends Pricelist cell H2. Thoughts?
Solved by I. S. in 30 mins
My report has a formula that changes text in "L" column based on the date (column "K" being greater than 300 days. I want to highlight and change column "L" text if date in column "K" is greater than 30 days past date. I'm not sure if this can even be done in conditional formatting or if it will work better in VBA, Any help would be WONDERFUL! Thank you!
Solved by Z. B. in 28 mins