Forum

Hi Rosemary, With Power Query you can use the Text.TrimStart and Text.TrimEnd functions - see attached file Text.TrimStart - PowerQuery M |...

Hi Mihai, Transpose (Transform -> Transpose) the table then you have 1 column of lists and you can expand them all at once. Regards Phil

Hi Viktor, The errors are caused because you have rows in your Production Data where the Site Name is a #N/A error, for example Row 1831 to Row 186...

Hi PB, Dates are stored as 'serial numbers' in Excel. Please read this for explanation Excel Date and Time - Everything you need to know (myonl...

Hi Viktor, Attached is a file that fills in the blanks as requested. There are a few issues though as there are some Site ID's where their Use W...

Hi Bakshi, Unfortunately Power Query doesn't have a way to login to websites that require a form to be completed via the web browser interface. If...

Hi Steven, This sounds like a job for Power Query - have you tried it? Please supply sample data files and an example of your expected result...

Hi Rutuja, You haven't supplied a workbook with sample data so I'm guessing at what you are working with. You could try this Sub FindWord() ...

Hi, What you're asking isn't clear. Please supply a sample workbook and an an example of what you expect as a solution. Regards Phil

Hi Bandi, VBA isn't enabled by default as this poses a security risk. If it is enabled it should not be. So you can't do what you ask because 9...

Hi Jacek, After adding the column, if you drag it into position so it's the first column, a new step is created which will do this every time. R...

Hi Jacek, Group the rows and aggregate the Number column by Minimum. This in itself will tell you if 1 exists, but if you want to create another c...

Hi Sebastien, The quickest solution would be to use the SUBSTITUTE function =SUBSTITUTE(SUBSTITUTE(H3," ", " / "),"License","O365 ") See atta...

Hi Jason, See attached file for solution using this code if [#"Difference in Days - Paid Date vs Last Scan Date"] >= 1 and [#"Difference in D...