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

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

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

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

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

Does anyone know the function to round up numbers. to the next whole number. i.e 0.02 roundup to 1 or 123.3 roundup to 124 any help would be appreciated. many thanks Robert cunliffe

hello If i have a number of entries in a field (in use) when crystal runs it generates separate entries but i would prefer it to display: entry 1, entry 2. can any one help?