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

Assigning numerical values to non-numerical text and finding the sum of multiple non-numerical texts that have been assigned values
Solved by M. Q. in 24 mins
Hi there, I'm looking for a formula to match a text within an array and return the results found. I know how to you use vlookup/match/index formula's, but I can only return the first match found. I would like to return the first match in cell A1 and the second match inside A2, third inside A3, etc. So when the first match is found and placed inside A1 then the formula inside A2 should ignore the first match that is already found and show the next match value. I would like to get this done with a formula and not with the autofilter option inside Excel.
Solved by A. W. in 29 mins
I would like to create an IF function formula that shows text in a cell(f5) if another cell shows text in another cell (c5). the text in Cell c5 is a drop down list with multiple options can this function be used with multiple texts?
Solved by B. U. in 25 mins
2 sheets On one i want to pull the following from the other Column A contains a text in the cells Based on a specific value in column A, i need the value in column b pulled into the other sheet.
Solved by S. U. in 12 mins
I need a macro that will flatten rows of data based on text in a field - there's a "like this" tab on the google sheet. I have 1000s of these files so I need something that will work generically.
Solved by B. J. in 27 mins
How would I write a formula that says "For an entire column, if a cell has text in it, and the cell above it is blank, copy the lower text into the blank cell above it."?
Solved by C. L. in 24 mins
I need a formula to use if in a column, if there is a cell with text in it, and the cell above it is blank, copy the text from below into the cell above
Solved by M. F. in 23 mins
Hi, Need help with a quotation speadsheet to be used by staff to stream line our operations, In the top bar i want a drop down list of the 3 types of sales option, this will then bring up a drop down menu in the column labelled 'product', with the price for each product appearing in the column labelled 'rate'. Each sales option has different prices for the products. All 3 options and products lists with prices are in tables in worksheet labelled 'products'. I have already had one done by you guys but all the text in the drop down menus aren't correct
Solved by C. H. in 12 mins
Trying to use a table to have an excel function looking if one cell contains certain text, then to output a word that corresponds
Solved by T. F. in 21 mins
I'm trying to create a table to make a function where I check if a cell contains certain text so i can output corresponding text
Solved by D. A. in 15 mins