Forum

Hello, If you start Excel first and then when in the Open file view, choose the option to open and repair. But this is also no guarantee that it wi...

Hello John, Have you read this article on how update data from files in a folder using Power Query? I believe that is the best approach for you. No...

Hello Joseph, I notice that you have different delimeters, spaces and commas. That makes it difficult to maintain text such as street adress etc. I...

Hello, ’There is no file attached. Do check out these articles, they might give you the needed start. https://www.myonlinetraininghub.com/text-to...

Thanks Phil, This is one of the hazards using functions in a different language and then translating when posting.

Hello, Instead of setting a fixed parameter of 5 characters in the LEFT function, use LENGTH to check how many characters the lookup value has. Usi...

Hello, ’What is it you want? If you can give an example it will be easier to help you out.

Hello, For reference. The LEFT function returns its value in a text string, so you need to change it to be a numeric value. Use below formula an...

Hello, If you haven’t already, do consider taking this course. Just remove the quotation marks surrounding the.number. =IF(C95<>"",1,"")

Hello Anand, It is always easier if we have a sample file showing the data plus the expected outcome. If the data is formatted differently, then it...

Hello, See attached file, column L. I have used the formula that Mynda wrote.

Hello, ’Check outsearch for SSRS and you will find several courses.

Hello Melanie, Have you seen these articles linked to below? They show two different methods to add drop down lists in Excel.

Hello Ali, Welcome to this forum. I will gladly help with any questions you might have in order to learn how to accomplish what you want Excel to d...

Hello Paul, Currently viewing your file from my tablet and don’t have full view or functionality, but will try to give some help anyway. Update:...