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

is there a way to do text to row instead of text to column
Solved by X. B. in 29 mins
I want to create a formula that gives me the results in cell D1(a hyperlink) using Cell A1 (text), Cell B1(text), and Cell C1 (which is a hyperlink)
Solved by S. J. in 15 mins
EX_20 in the description I need to take the text from cell a1 & b1 and add it cell c1( a hyperlink) to produce the results you see in cell d1.
Solved by B. F. in 12 mins
I need the command buttons to fill the notes text box without overwriting eachother
Solved by K. A. in 30 mins
i want to know something if i enter a value in one cell. another cell should display a text starting with the value entered from a range of cell i have given
Solved by M. F. in 11 mins
I need to lookup a cell in an array where each cell within that array may contain other text as well as the lookup value (partial string match) then return another column to the right of the array on the same row. This then has to be repeated to capture every row where the lookup value appears within the array. I am sure this can be done in VBA but I am not sure how.
Solved by X. Y. in 25 mins
This is somewhat complicated and I understand if it's a bit out of the realm of online assistance but... In simple terms I am trying to have a series of drop down lists in Column A for eg. A1-A5 "Tiles", which upon selection in term populates a series of cells in column B with data lists from other sheets eg. B1 "Name" B2 "Code" B3 "Size" etc.. This then prompts the user to manually fill out column C. They are all text based cells. I have managed to get a working system for one set however my issue comes when I want to drag down multiple versions of column B - the references to Column A and the data it is drawing from break as they are following down the data sets to match and eventually run of out reference cells, when actually I want to re-set the reference to the top of the data list for each new Column A category. I hope that somewhat makes sense!?
Solved by V. W. in 22 mins
need the formula to find out the number like phone number and mobile number and remove the email addresses from the string of a text
Solved by M. H. in 26 mins
want to separate mobile number and phone number from a string of text
Solved by T. S. in 23 mins
I have created a matrix of 9x9 cells. Some cells have number values and others are just empty. I want to set up this matrix such that those cells with numbers in them are displayed in a specific text style and size while those with no values I want the cells formatted to a different text style and size so they will appear different when a number is entered. I have been trying to do this using a macro but I cannot create an "IF" conditional just copying key strokes. It seems to need Visual Basic code added manually to the macro to fulfill my need and I don't know VB. Can you help me please?
Solved by X. S. in 17 mins