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 want to know how to assign a block of text to a button, and clicking on that button will paste the block of text into a cell additively, without overwriting any previous button clicks that have transferred over other blocks of text. Essentially... how do I create a note taking template whereby I can click on buttons to format an entire document?
Solved by A. J. in 22 mins
I need to work out if on cell is greater than 6 then another cell needs to put this figure in but minus 0.5 Also can i get another cell to add text 'BREAK' if a cell is greater than 6
Solved by O. L. in 19 mins
hi I need a formula to find text in "string text" that placed in one cell
Solved by A. Q. in 24 mins
Hello, I'm working on an excel project. I had near completed and made the final step of inserting a text object - linking this to a word document. After doing this, the document appeared, however wasn't in full. The main problem I have is that I have seemed to of deleted the formula that came with the inserted object and now, when I attempt to make any changes at all to the excel project I get the error box saying, 'reference isn't valid'.
Solved by B. H. in 19 mins
I have an excel spreadsheet with two worksheets. And the following formula is not pulling the data. =VLOOKUP($A$2:$A$566,'Module Type Info'!$A$2:$D$97,4,FALSE) In sheet 1, I am using all data in column 1 for the lookup In sheet 2, I have selected the first 4 columns of data for array I want to pull data from sheet 2, column 4 into sheet 1 Both tabs are sorted alphabetically. Confirmed that the value in column 4 of sheet 2 is a TEXT field. Why is this not pulling the info from sheet 2 into sheet 1
Solved by F. L. in 25 mins
Formula to look at a text value and then count a range with a view to summing a range of cells based on the count
Solved by K. F. in 21 mins
I need a cell to populate on text if one cell states something but different text if a different cell states something
Solved by S. Q. in 11 mins
Hello, I am trying to cut off the overflowing text in a cell
Solved by I. W. in 25 mins
Select the range B3:D3. Center the text in range
Solved by A. A. in 26 mins
need to count text in excel cell if it contains my test or not
Solved by G. Q. in 24 mins