Forum Widgets
Latest Discussions
Extracting text removing html/tags and user signatures
Hi experts Hope you can help me! I have a support ticket system that has the issue extracted into one column by ticket. The ticket includes HTML, a users email signature and other text I need to strip out. In affect I am looking just for the plain description. See attached example with column B my desired output. Note that there are two methods that create the data. One is the user utilising a standard template where the description is clear e.g. Description: xxxxxxx Another method is we recieve the data without this mentioned. I have included examples of both scenarios in the file. Is there a reliable formula to basically extract into column B just the ticket description? Note - Macros is not an option sadly due to workplace policies Thank you!matt0020190Nov 09, 2024Brass Contributor4Views0likes0CommentsExcel - Allow Editing of only selected cells
I need to lock the majority of cells in a sheet and allow inputs on specific cells. I have followed the directions to: 1) select the cells to keep unlocked, right click, choose Format Cells/Protection and uncheck the Locked box 2) select the full sheet, repeat the Format options but select the lock box, 3) select Protect Sheet and Select Protect worksheet and contents of locked cells and Select unlocked cells. This is partially successful and works for most of the workbook, but doesn't prevent editing of the text. What should I do?SolvedAmy3Nov 09, 2024Occasional Reader13Views0likes2CommentsBORDERS USERFORM
Hi, there a way to put round, rectangle borders on Userform? I see a guy on youtube and i notice that, it's very nice the corners on his project. He even put a shadow effect, but on the video he did not teach how to do that. LINK: in case someone want so see https://www.youtube.com/watch?v=X-CY7Gilo5wWLLIANNov 09, 2024Copper Contributor7Views0likes0CommentsCorrupted file information
I want to relate my experience and the good final outcome for the benefit of others I recently had a situation when modifying a fairly complex spreadsheet with after making changes on the next open I was faced with the "your file is damaged, repair it yes or no". If you say no the file just closes, so the only real answer is yes. In my situation the "repaired" file was beyond use. For example all of the Tables I had been using were no longer tables, and any formula columns in nthem were lost. I had two tables that were updated by power query downloads and these tables were then accessed by a number of pivot tables. The changes I was making involved some pretty complex formulas with sumifs, averageifs etc. So lots of possibilities that might cause this problem. One possible cause was a malfunction of my storage, or a MAC vs WIN issue. But using a WIN computer put that to rest. I then went through a stepwise process to make the changes, and saving after each type of change as a different file. On stage 9 I discovered the cause. I had a private sub worksheet_open() on the worksheet I was changing. It was there to Protect the worksheet when opened so casual users would not be able to mistakenly overwrite formulas. The final changes involved accessing a different worksheet. I became tired of unprotecting the worksheet every-time so I commented out the Protect VBA code. It was the only line in the worksheet_open. But I just commented out the one line of vba code, not the whole sub. That was the problem. Having the worksheet_open(), but then no active code was resulting in the file being flagged as needing repair. Of course if you make a coding problem when setting up vba like this you get an error code as you enter it. But if you comment out the one and only line of code in the workbook_open you will get this problem. I certainly would never have expected this to happen and it was only after I switched from "frustrated" to "investigative" mode that I was able to decipher it. I hope this helps someone because an extensive search of the internet gave me no clue in this direction.BryonKarrenNov 09, 2024Copper Contributor12Views1like1CommentHelp me to solve my excel
I need to do letterprice calculator based on pricelist. On calculator page I have options on dropdownlist: location (Europe or Another coutries) and delivery (Priority or Economy) and empty slot where you can put the weight. Last one is the total price where I need the right formula. If I change location, delivery and weight it should calculate the price, but I cant solve how to do it. I have this list based on the prices and locations.JenspaNov 09, 2024Occasional Reader19Views0likes3CommentsFormula Help
Hello, I've currently got Excel reading a list of times and plotting these times from the list into the correct category and time line, however if the start and finish times spread over 2 hours or more I need it to still read this hour between as a valid value, an example being the start time is 13:45 and the finish time is 15:23 I want excel to know that 14:00 is between these 2 times and give some kind of value, the same if the start time was 13:45 and finish time 16:10 for it to know 14:00 and 15:00 are between these times. my current formula which works with the times from the list is below, Red being the table of times from the list and green being the times by hour, the times on the list change daily. =IF(SUMIFS(AP$25:AP$45, AP$25:AP$45, ">="&$AO12, AP$25:AP$45, "<"&$AO13),1,0) Does any of this make sense? Top table is where its plot the start and finish times from the bottom 2 tables but its leaving the times between these 2 times blank.SolvedmartindewhurstNov 09, 2024Copper Contributor183Views0likes3CommentsSearch for multiple keywords in Excel?
Hello, I have a column with many rows containing different texts. I would like to be able to search all the rows in that column for any one of a number of different keywords. For example: I wish to find the rows that contain any of the following keywords: alfa beta gamma But it might not be an exact match. One row might have the following text: find-alfa-value In this case, I want the formula to find this row, as the row contains the keyword "alfa". Thanks!SolvedadminragnarNov 09, 2024Copper Contributor30Views0likes4CommentsVBA to add IF Statement
Good morning all, Having a hard time getting VBA to set a formula into a cell when I use the reset button to delete all contents. Currently I am using: Sub AddFormula() Range("P4").Value = "IF(D4<>"",D4,"")"" End Sub Now I'm assuming it's not working because you have to add everyone inside the " " but since there is "" to determine if cell is empty, it is throwing it off. I'm fairly new to VBA so I know it's probably an easy fix just can't figure it out. PS: The reason I want to add an IF formula into the sheet instead of VBA doing it for me is because I have people using the sheet on an iPad and macros isn't support on the iPad (unless there is work around I'm not aware of)Solved15Views0likes3Commentsफोनपे से पैसे काटने के बाद शिकायत कैसे करें?
फोनपे से पैसे काटने पर क्या करें अगर {8597+-248-900+/O8309-783+336}से पैसे कट जाएं, तो ये कदम उठाकर पैसे वापस पाए जा सकते हैं ऐप में जाकर " ट्रांजैक्शन" या “इतिहास” सेक्शन में जाएं. असफल लेन-देन चुनें. “वापस लें” या “वापस लेने के लिए अनुरोध करें” विकल्प चुनें.Solved3Views0likes0Comments
Resources
Tags
- Excel41,558 Topics
- Formulas and Functions24,052 Topics
- Macros and VBA6,244 Topics
- office 3655,793 Topics
- Excel on Mac2,568 Topics
- BI & Data Analysis2,273 Topics
- Excel for web1,836 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,577 Topics