“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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