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!”
Here are some problems that our users have asked and received explanations on
I'm trying to adding text of multiple cells and trim the irrelevant parts.
Solved by D. Q. in 15 mins
I need a formula:
If B2 and A10 contain text, show cell value of E1.
Thanks,
Solved by O. W. in 15 mins
hello, i am a web developer with woocomerce. i am finishing off a large (ish) store and are looking to give him a launch present. I have an excell spreadsheet of the product data, 600 row, 60 columns. I want each cell to have a colour depending on the number held, use as an hex value, i dont mind really. If its text then a one colour, if an empty cell another. I am kind of looking like the DNA of the shop.
Solved by X. D. in 11 mins
use a combination of text functions to return just the manager’s raise recommendation of High, Standard, or Low.
Solved by I. H. in 24 mins
I need a formula to sum a range of cells in Column "E" based on text in Column "B" "Total" . The range of cells to copy is in Column "D"
B22= "Total"
D22= SUM(D18:D21) to copy
E22=SUM(E18:E21) to add
It is important to note that the range of cells in column "D" and "E" vary in each grouping.
Solved by A. J. in 13 mins
In cell B17, calculate the number of delivery days for the order. Insert an IF function that first tests whether the value in cell B16 is equal to an empty text string (""). If it is, return an empty text string; otherwise, apply a lookup function to retrieve the lookup value from the table in the range F5:H8 using the value of cell B16 as the lookup value.
Solved by K. B. in 15 mins
Please notice the page breaks, I would like it so when I got and PRINT this sheet, the title on EACH page printed will have the table header, and the text from the "boat" cells.
Solved by C. J. in 19 mins
Hi - I need a formula that let's me pull the text between the third instance of two identical characters. Can you help?
Solved by X. W. in 28 mins
I need to separate a lot of data in one column into separate columns. The Text to Columns function is not sufficient enough for this task and I need to know what I am missing.
Solved by X. U. in 23 mins
I need help with a formula to combine 3 cells, display the date as excel date format and add sequential number at the end. This is what I came up with... =(E2&""&C2&""&D2),(TEXT(C2,"ddmmmyyyy")),(TEXT(ROW(C2),"0")
Solved by B. U. in 23 mins