Search results for query: *

I have all machines apart from one connected to a switch. The switch and the spare computer are connected to the Gateway. All machines have fixed IPs 192.168.1.111 - 119 255.255.255.0 192.168.1.254 We also have a NAS connected to the Switch. The new computer connected directly to the Gateway...

Hi Does anyone know if it is possible to show Spaces, Nonbreaking spaces, carrage returns using either CSS or javascript in editable text boxes on a web page? Doesn't have to be exactly the same but like MS Word does. We just need to see if it is a space, tab or return some?fonts,?such?as?¶

I am using another tools that uses Access in the background and we have no modules. We can only use queries

It is Access. This finds all the rows with USD [Source] Like "*" & "USD" & "*"

How do I find all cells that have 3 capitals letters in them. USD GBP EUR etc

Perfect thanks

Hi, I am not very good with syntax but I need to find cells that have a full stop then a space in one cell but not in the other. I get an error with this [Target] Like "*" & Chr(46)Chr(32) & "*" AND [Source] Not Like "*" & Chr(46)Chr(32) & "*

Ah, thanks

Hi Tony, Just opened the 2003 version you created in the English version and my Swedish version translated the function straight away. I copied the resulting function into my larger working file and it worked perfectly. This is what my Swedish version created from your English version. I am...

OK, let me explain as I may have been doing things wrong. The first couple of rows don't actually have an exact match I am pasting your code into G1 and then dragging down but it keeps refering to $B$2 Look what happens on row 12...

OK, I tried a different row =SÖK($B$25;D25)where I knew the text was exactly the same (even casing) and it returned the number 35 In column B Strawberry Cactus In Column D We stayed in the Strawberry Cactus rooms for 2 nights. Result in column G We stayed in the Strawberry Cactus rooms for 2...

I get #VÄRDEFEL! valueerror in English ??

Now it just copies over column D but doesn't surround any names with <b> and </b>

Guys, where can I change the language settings used? I am on a Swedish machine and to get Tony's first solution to work all I had to use was theSwedish version of =SUBSTITUTE I found a list of all the function translations here...

Any way of it not having to be case sensitive? John Smith John Smith (finds) john smith (doesn't find) john Smith (doesn't find)

Thanks that worked nicely :-)

First le me confess that I posted this on another forum but the answer I got required knowledge above my head. I have a list of names in column B In columns D-F I have sentences and the person's name is somewhere in the sentence. I need to be able to surround the name with teh html code <b> and...

Nope

Hi, We have 3 new Win 7 machines. All 64 bit but different hardware and user profiles on each machine. I need to install about 25 programs (all the same) on each machine. Are there any tools that can save me doing the same thing on all 3 machines. 2 machines are in the office and 1 at home. I...

We are actually searching in a tool that conencts to an Access datatabse and I suspect it is old. Thsi is from the help file Note: Desktop Workbench uses Jet SQL from Microsoft® Access. Therefore, the wildcard character is * (not %, as with regular SQL). For more information about the LIKE...