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 need a formula that will search a cell with multiple vales in it (words) and will return whether a specific defined string of text is in there.
Solved by A. Q. in 30 mins
Yesterday I was working on a project involving drop down menu excel and I wanted to pick a company name from that drop down, then based on the company chosen, I want the company address to appear in a cell below and the phone number to appear in the cell below the address, can you help? Basically If the company I pick from the drop down menu is Company A then Company A's mailing address will generate in the cell below the drop down cell and Company A's phone number will generate in the cell below the address. I have gotten the drop down to list all the companies using Data Validation but every Function I use after to transfer the correct address based on the company chosen will not work. The only way it works is if it brings over numeric data but I want text.
Solved by B. F. in 18 mins
I want to be able to have the text that appears in column F to be blank until data is entered in column E. Once I enter column E data will appear or not appear depending upon the data entered. I have that part set. I just need to have column F be blank when column E is blank
Solved by D. W. in 28 mins
Have been helped on this earlier, not sure how to put it into my spreadsheet however, most definitely need some help one this subject! Summery; I am trying to sort my spreadsheet by text colour using 5 separate colours, and i wish that when i put my formatted data in a main sheet, the colours are automatically copied over to another another 5 sheets, each only containing one colour
Solved by T. S. in 29 mins
Trying to continue from another expert on copying formatted text to another spreadsheet
Solved by S. S. in 26 mins
Hi, I have a list of image names on a spreadsheet. I would like to map these names on to their corresponding lines on a second spreadsheet. However the image names contain additional text before and after it... Is this possible to do through any vlookup alternative? Many thanks in advance.
Solved by V. E. in 13 mins
Hi I'm trying to create a formula that if text in a cell is found in an array on another sheet within the workbook, then place the number in the cell adjacent to found text in the array... any thoughts?
Solved by K. U. in 28 mins
I have info imported into a spreadsheet through Zapier. When the info is dropped in, I want a certain column to display "yes" if there is text placed in it and left blank if it's blank.
Solved by I. J. in 19 mins
i'm trying to conditionally format a cell in one sheet (format text) based on the value of a cell in another sheet. google sheets says it can't be done. can you help
Solved by I. W. in 18 mins
I have to create a report on excel with many tables. How do I make each page in excel independent of each other. I am asking this question because as soon as I start editing a table (changing row height) to ensure all the text fits clearly, the tables on the pages start shifting up or down. I need the format of the report to stay constant and hence I need to ensure if I make a change to one table, the position of the other tables remains unchanged
Solved by M. Y. in 17 mins