Search results for query: *

I have a column called notes, i would like to move the data from each cell in this colunm in to a 'note' in the adjacent cell for the same row. Any ideas? office xp win xp

Hello, I have some data in a spreadsheet that i need to validate. I need a formula that will produce the result in column D. Here it is: A B C D a 1 100 ok b 1 100 ok aa 2 100 check aa 2 100 check bb 2 200 ok xx 3 200 ok yyy 3 200 ok a 3 200 check a 3 200 check What it...

many thanks - worked a treat!

no i want it to stop when it gets to "nature of call:" So it only returns the x's after "Room:" and before "Nature of call:

Hi I have come back to this thread as i have a further requirement that i cant get my head around. What changes would i make to the formula below so that it would only return the "x's" after Room Number and Nature of Call? mid({table.field},instr({table.field},"Room: ")+6, 5) The number of...

Name: xxxxxxxxx Date: xxxxxxxxxxxx Location: xxx Room: xxxxx NAture of call: XXXXXXXXXXXXXXXXXXXX I would like to return the 5 x's after "room:". Please note the number of any of the x's can change and go on to 1 or more lines. thanks ROob

Hello, cr10, mssql ole db. i have a field in a db that contain very long text. What i would like to do is find a sub string (which will always be the same) within the field and return the next 5 characters after this sub string. Can anyone help? Many thanks Rob cunliffe

Many thanks for your quick reply. BUt im a bit unsure what you mean Could you provide some more details, an idiots type guide? Many thanks Rob

Hello, Using Excel xp. On Windows XP. Excel VBA. I would like to insert 6 blank rows after each current row. So if i have data in rows 1 to 1000 i would like to insert 6 blank rows between the current rows. Can anyone offer any help? I have a recorded macro that looks like this...

Anyone?

what do you mean?

Hello I am using office XP writting some VB for excel. I have a fairly simple command that will sort data. The user will click on a button to bring up a userform. The userform has a combo box. The combo box entries are cells (i.e. a5 , g5 etc) The user selects a cell they wish to sort on and...

thank you immensley, this is perfect. Thanks very much

It works sometimes but not in all cases. Sometimes it deducts the right number of days (for the weekend and others it does not. i think the problem lies with this bit of the formula: WeekEnds := (Truncate(Days/7)*2); what if the start date was a thursday and the end date the following...

lbass, I apologise for not being clear. In my previous working (not excluding weekends) i used the datediff formula. datediff ("n", {@dateandtimearrived},{@datetimestarted})/1440 I asked the syntax to display the result as minutes, see "n". I then divided by 1440 to put the result in to days...

Hi Many thanks for your help. The problem is the change you have made only dispalys the number of days as minutes. What i really need is days displayed as a fraction. so one and a half days displayed as: 1.5 ROb

Hi all, I am using a formulae (using crystal 10) to so that the number of days between two dates ignores weekends. The formula is lifted straight off the business objects web site. However i have a problem. I need not only to work out the number of days between the dates (ignoring weekends)...

Hello, If i use Ken hamady's formulae. He says that you need to manually input all the holiday and non business dates. For weekend dates can i use a loop? i.e specify the first weekend and then just add 7 days? Cheers p.s. using CR 10 now. Rob

Hello This is how to always round up: If {number.field} - truncate({number.field}) <> 0 then truncate({number.field})+1 else {number.field} The logic is that is when you truncate a number, you throw away any decimals. Subtract the truncated number from the original number and you can...

Many thanks for your help. I am using crystal reports 10, i apoligies for not stating this. This forum is mostuseful and its great thst there are people willing to help others. once again many thanks Rob Cunliffe