Recent content by robcunliffe

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...