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 copied my sheet into a new tab. Now i need to inset the new data numbers into the copied sheet but when i do i just end up with #DIV/0! all over the place. Im assuming i have it in text and not numbers? please help
Solved by F. Y. in 20 mins
I need to batch data based of another Cell. My goal is to have a selection from a drop down. Example "Micro Lab" or "Pharmaceutical Lab" auto populate on a cell when the cell next to it gets updated with Data. For example, you select the drop down. Then you enter data into Column A. when it is entered it pulls the Text "Micro Lab" and pastes it to the same row in Column B. However. When you change the drop down from "Micro Lab" to "Pharmaceutical Lab" it would not change your previous work allowing you to auto populate data to a table based off some drop downs.
Solved by V. F. in 18 mins
I am trying to use, I believe =vlookup to check for exact text in one cell, then the number directly adjacent to the cell. I am trying to add the numbers of the adjacent cell as long as the names match then add them up. In the file, I am only using the months from August to now for the point accrual. And under the ACCRUED POINTS sheet is where the I would like the data to be added. I can't just use =!DECEMBER! CELL# due to the data shifting so it needs to be exact match + the number next the name and then add the total points between sheets.
Solved by B. F. in 22 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 an excel 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 D. E. in 29 mins
If I need to bring in text field into an excel spreadsheet
Solved by G. F. in 22 mins
if i need to bring through a text column into a pivot can I only d this using a table?
Solved by S. Q. in 15 mins
Hi, I need a formula that determines whether text is in a given cell in six separate tabs and return a different value for each. I've tried to string ISTEXT, but am stuck and it doesn't work. Please help! Many thanks!
Solved by S. H. in 17 mins
how do I apply different text colors in one column based on values in a previous column? Ex. for any row for which there is a 1 in column B, I want the text in column C to be red?
Solved by X. U. in 24 mins
a row has multiple values. In column A a text is displayed, if the same text is displayed in the next row, it should copy the whole row where the same text is displayed
Solved by C. D. in 20 mins
I am trying to find a formula that will return an error if the text is 'E' and true if the text is 'A' but also if it is missing data?
Solved by S. J. in 20 mins