legal

Hi all, I am trying to separate string from a cell based on character present and add it after to HTML body. Sample text (all in one cell): <tbody> Need to separate it by ";" and add it to HTML body for better look, like this: Think this is somewhat common problem, but can not find a...

Hi guys, I need a formula with a sum for data. Example, I halve these data: <tbody> <tbody> PE - PESCARA - CAFFE </tbody> <tbody> 3030 </tbody> <tbody> TAX </tbody> <tbody> PE - PESCARA - CAFFE </tbody> <tbody> 3636 </tbody> <tbody> TAX </tbody> <tbody> PE - PESCARA -...

Hello, I need to build the following formula, in column A I have legal name and in column B preferred name. If the Legal cell is blank, I want to return in C the value from B with two other conditions. Say in A1 the value is blank, in B we have D.O’Brien. What I need in C is D O'Brien I need to...

Hi all, I've been trying to convert the below code from sql server to run directly from excel vba. But unable to do so. Update Legal Set Category = Case when datediff(month,GETDATE(),[End date])>6 then 'Blue' when datediff(month,GETDATE(),[End date])<6 and datediff(month,GETDATE(),[end...

This is an odd one (at least to me). So I have a file I received from our legal department with dates in column E that when I copy and paste them into a new spreadsheet the date drops 4 years for some reason.? So for example the date in cell E4 in the legal file is 02/28/2017... when I copy...

I want to know the formula for the following example; I want to be able to select the following in the range of M2 through M30 <tbody> 100%: 90%: 80%: 70%: 60%: 50%: 40%: 30% 20% 10%: 10%: 0% </tbody> If i select any of the %'s from MY COLUMN M above, I want the...