Get instant live expert help with Excel or Google Sheets

“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

Hello, I'm using Excel as my register system. I can not get the total bar to calculate over $100 dollars. the formula is in B20 it is =SUM(B2:B19) if the amount i enter exceeds 99 it cell B20 displays #### instead of a total. Same thing with cell B22 which is where it should display change. WHAT DO I DO Please Help!
Solved by E. J. in 19 mins
Hi I need help for a formula to convert text into columns in excel. 100150!Abacavir Ziagen 20mg/mL 240mL Mixture 240mL!553036!CP use 100151!Abacavir - Lamivudine Kivexa 600mg-300mg Tablet 30!553036!CP use 100152!Abacavir - Lamivudine - Zidovudine Trizivir 300-150-300mg Tablet 60!553036!CP use 100155!Abacavir Ziagen 300mg Tablet 60!553036!CP use 100200!Abciximab Reopro 10mg/5mL Inj 1!550131!CP use 100201!Filter - Sterile Durapore PVDF 0.22 micron For Use with Reopro 33mm Unit 50!556031!CP use 100210!Abatacept Orencia 250mg Inj 1!554006!CP use 100230!Acamprosate Campral 333mg Tablet 180!554231!CP use 100250!Acarbose Glucobay 50mg Tablet 90!550076!CP use 100255!Acarbose Glucobay 100mg Tablet 90!550076!CP use 100831!Acetazolamide Glaumox 500mg Inj 1!555111!CP use 101047!Acetazolamide Diamox 250mg Tablet 100!555111!CP use 101400!Acetone Merck 100mL Solution 1!556031!CP use 101408!Acetone Merck 2.5L Solution 1!556031!CP use 101792!Acetylcholine Miochol E 20mg/2mL Solution 1!555111!CP use 101987!Acetylcysteine OmegaPharm 800mg/4mL (20%) Inhalation 10!555031!CP use 101988!Acetylcysteine DBL 2g/10mL Inj 10!556031!CP use 102100!Acitretin Neotigason 10mg Capsule 100!551051!CP use 102115!Acitretin Neotigason 25mg Capsule 100!551051!CP use 102500!Adalimumab Humira 40mg/0.8mL Prefilled Syr 2!554006!CP use 102503!Adalimumab Humira 40mg/0.8mL Prefilled Syr 6!554006!CP use 102507!Adalimumab cartridge Humira 40mg/0.8mL Pen 6!554006!CP use 102508!Adalimumab Humira 20mg/0.4mL Prefilled Syr 2!554006!CP use 102509!Adalimumab cartridge Humira 40mg/0.8mL Pen 4!554006!CP use 102510!Adalimumab cartridge Humira 40mg/0.8mL Pen 2!554006!CP use
Solved by X. Q. in 17 mins
Hi, I have an excel file with 6 columns. Columns B-F are the columns I need help with. I need HTML inserted in each cell. Then I need all of the cells in each row to be combined in a new cell with each bullet point on a separate line within the cell. Please Advise Thanks
Solved by E. J. in 15 mins
Hello, I have weekly data (more than 1000 data points each week) collected that I would like to plot them using excel. I want to know how to add each week data into the same worksheet without having to re-plot the data again and again. I also would like to have the axis label by monthly (for example: Day 1, Day 30, Day 60, etc.) Thank you so much for your help. I'm truly appreciate it. Sincerely, Wish I know Excel more.
Solved by K. F. in 14 mins
Dear Expert01, I couldn't upload the excel binary workbook (.xlsb) here since this did not let me. I was hoping if you can help me figure out how to add more data without losing the format of the previous data already on the worksheet. When i upload data, I made sure that the date column is formatted to MDY but it somehow did not applied when the new data added into the current worksheet. Thank you!
Solved by I. C. in 20 mins
I need help trying to get excel to show the difference between two numbers for an entire spreadsheet. Please Help!!!
Solved by B. H. in 23 mins
Hi I need help with an excel spreadsheet to create a formula to do a certain function
Solved by G. S. in 12 mins
Good Afternoon, We have set up an excel spreadsheet and are running a Visual Basic formula on our Windows computer but this will not copy over to our Mac.. The formula is shown below.. can you please help with how we can run this formula and make it compatible between both the Mac and Windows computers Thank you
Solved by E. L. in 19 mins
Hi, I need to translate an excel sheet from spanish to english, as I don't speak the language. Please help
Solved by K. Q. in 15 mins
The data in the Excel spread sheet attached needs to be collected into a table and generate a set of charts and graphs in order to expose a possible trend. Then Calculate the mean, standard deviation and Z-scores for each set of seven-day data points. i Need help
Solved by Z. H. in 12 mins