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

In worksheet 1, cell A1, I have the text Tanka. In worksheet 2, cell A1, I have the text Tanka Bar. In worksheet 1, cell B1, I want to look for "Tanka" in worksheet 2 and return "Tanka Bar". I have 5000 rows that I need to look for a part of a text in worksheet 1 and return the full value from worksheet 2. So putting the word "tanka" in a formula isn't feasible.
Solved by G. A. in 13 mins
How to do an excel convert text to date?
Solved by M. D. in 13 mins
Trying to express total value in dollars for Source column, Cost column, Delivered customer Column (while some columns are numeric, others are text) with an EOM function
Solved by X. U. in 20 mins
I am looking to export part of an excel spreadsheet: only those lines that have some text in Column x. How do I do that please?
Solved by C. F. in 16 mins
Hi, I need to extend the width of a data validation menu so I can see very long text that is larger than the column of the data validation. I want the column to have 8 width but the excel pull down menu to have 25 width
Solved by O. B. in 15 mins
Add a formula to cell G4 that creates a Report ID from the date and the ID number on the ListData worksheet of the person who made the report. The IF function will include a TEXT function and a nested IF function with a VLOOKUP function. The logical test will verify if cell G2 is greater than 0. The value if true will include the TEXT and VLOOKUP functions: TEXT(G2,"YYYYMMDD"),"")&" "&IF(G1>0,VLOOKUP(G1,ListData!B15:C19,2) The value if false will return blank.
Solved by E. A. in 13 mins
I need to extract the words side-view or SV from a text
Solved by Z. Y. in 29 mins
convert a cell that has a formula into a text without losing the vaule
Solved by K. S. in 23 mins
I was given this formula to use with this document but its not working for me. "Copy this formula and save it somewhere. =iferror(text(date(right(L1,4),mid(L1,find(""/"",L1)+1,find(""~"",substitute(L1,""/"",""~"",2))-(find(""/"",L1)+1)),left(L1,find(""/"",L1)-1)),""MM/DD/YYYY""),"""") Everytime you receive the source data, paste that to M1. And then drag it downwards. After dragging it downwards, copy column M and then paste it over column L as VALUES."
Solved by M. L. in 16 mins
Hello! I need help with this file. I have a tab on here called "Master Pool". On this tab are four columns I need to extract data from. They are Accessibility Hold 1, Accessibility Hold 2, Accessibility Hold 3, and Accessibility Hold 4. For each row in the sheet, these columns will contain some written out information. This information is separated out, and there are only certain things that will appear in each cell. The information that appears in each cell can be found in the tab "A11Y Tag Placements". There you'll see headers called "Field 1, Field 2, etc." These headers correspond to the "Accessibility 1, 2, etc." fields in the tab "Master Pool". These are basically the options of what can be written in each cell, Here's the issue- for a specific cell, these options may not all appear. In most cases only one or two options appear. What I would like to do is this: I need to search these cells and find specific word strings. For example- I need to search cell X2 in the Master Tab, then I need to see which of the values that could go there are actually there. I need a formula that can search the cell and respond with a whether that specific text is there or not. So in the example, I would like to create a search formula in excel for the word "ASL" in cell X2 that let's me know whether that's there or not.
Solved by T. B. in 11 mins