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 need a formula that bold's one row of text A2 to F2 and I need to also put a border around A1 to F12
Solved by I. C. in 18 mins
I'm trying to extract a URL link that is embedded in a text. Google sheets allows you to do it with the function =linkurl(a1).. but I want to have the ability to do it in excel because google sheets lags behind with any high number of data and REFs out.
Solved by I. E. in 20 mins
i need a function to calculate the number of x(text value) in a row which has values of (x,y,z) and auto restart every time
Solved by Z. H. in 18 mins
How do I clean up text that is not visible in a cell? It's throwing off one of my formuals.
Solved by Z. J. in 14 mins
I have a tire storage spreadsheet for a shop. I want to set it up so that when I change the date that the tires were stored, I can then get the entire row to change text colour. But the date ranges vary depending on the season
Solved by B. B. in 16 mins
Hi, I'm trying to split the contents on a cell with out losing the leading zeros. Every time I press text in the text to columns drop down it only keeps them for the first number.
Solved by A. D. in 29 mins
I want to create a formula that adds text to a cell
Solved by F. J. in 21 mins
Need to use IF formula to identify People Data location code. Insert new column A to Tampa Space Data tab, label column. Enter If or IFERROR/If statement to bring in the location value from Tampa People Data where an error #N/A result returns the text "Not CTO"
Solved by D. H. in 19 mins
I have a large excel file and one column filled with duplicates. I'd like to find and replace all the cells containing the same long text, but it's unable to replace it.
Solved by V. H. in 20 mins
Hi, I'm currently trying to set up a formula that helps with autofill of an email template so that I can insert each person's name and a bit of text corresponding to that person from a list on another sheet, without having to type it all out?
Solved by F. F. in 26 mins