Recent content by jimdevon

Thanks guys.

Thanks kjv1611. I have another question, just curiosity. If I concatenate a cell, can the contents be made permanent. In other words, can the concatenated data be fixed so it is no longer dependend on the parent cells? Thanks for the help on this one. It worked beautifully,

That is it! What the deal is I just rolled out about 50 new laptops. I need to create a sharepoint document with the IP, mac address, etc. The mac address field should normally look something like 23.rt.45.3g.45.gj (not a valid address, but the format is right), what I got is more like...

I could, of course, use left * starting at, etc. but I would think you could just create a cell format with the . and paste the cells, but apparently not, at least as far as I can tell.

No, just letter and number combinations all together.

I am trying to take a cell with a text format and add dots between each set of 2 characters for showing a NIC mac address. Thanks in advance.

Thanks again Linney. I finally decided to keep my new installation on the new drive and reinstall my software. It allowed me to start with a clean drive, since I install some software temporarily, which slows down my system. JS

Linny, Thanks for the info. It helped me to access my files on the hard drive. I can now import them to my new drive. I wonder if you know how I can access the boot.ini file on my old drive. This would allow me to repair it, which would mean I would not have to reinstall my programs. Thanks...

I have looked, and could not find a solution for the problem I have. I was having problems with Windows XP Pro on my laptop. I decided to reinstall XP. During install, on reboot, I received an error message. Everytime it reboots, it reverts to install, then reboots, in a loop. I know I can...

Help!! A company I do work for has had a crash in the Domain server. Here is a brief background. This is a nursing home in a small town. Noone knows who set up the network. The system has a domain controller (W2000Server), and a database server (NT4 Server). They called me and said the computer...

I cannot get this to work. IIF([wholenm] = "," , 1, 2) also tried IIf([wholenm]= *","*, 1, 2) no luck always get "2". The field wholenm has this format (Smith, John), problem is some people at this company just entered (John Smith). I need to use instring and lenght to pull first name...

Help, I am a network and database consultant. Problem is that some of my clients are small, so I have to be everything. Hardware troubleshooting is my weak suit, and I normally tell my clients that they would be better off buying new equipment rather than paying me to fix older systems. I would...

Wow, this thread has grown to Biblical proportions. In case any one is still interested; I think the raster vs. vector discussion has been run into the ground so to put in my two cents, CorelDraw is equivalent to Adobe Illustrator (drawing (vector art)). Corel PhotoPaint is equivalent to Adobe...

Ooops, my bad. I didn't pay attention to your code. I see that you are saving the results to excel. You could of course still follow my suggestion, and then analyze in excel. Sorry for the bad, Jim

Thanks, Duane. Worked perfectly. Where can I find a list of such objects?