I have an excel file that has one column and 39,980 rows. I need to take that and have it put it into a comma seperated file. Ex. A1,A2,A3,A4 I need all of these in a single line file.
Any ideas?
Thanks!
Because each value is in a new row it doesn't put it in a comma delimited file. It just puts each on its own new line. That woul work if I could replace each new line start with a ,.
I have an excel file that has one column and 39,980 rows. I need to take that and have it put it into a comma seperated file. Ex. A1,A2,A3,A4 Any ideas?
Thanks!
I have 12 columns each containing a 0,1,2,3 or 4. How can I take these 12 columns and have it total the 0's,1's,2's,3's and 4's into 5 more new columns? Again, I want it to count the number of 0's for example and place that in a new column. The numbers corespond to how long an account has...
I currently have a 2000 Server acting as my domain controller, file server and terminal server. We are wanting to move the terminal services to a new standalone server running 2003 Server. I have 30 Windows 2000 server CAL's and 15 Windows 2003 Terminal Services CAL's that I use now. I know...
I'm wanting to prefill a sheet with the formulas needed so that a user only has to enter two values and print the results. But I can not fill the formula down or I get #DIV/0 errors and they print on the sheet. How can I have these formulas pre filled down but hide the Divide By zero error...
We have a Samaba share set up on a Windows 2000 Server box and are able to browse the share with ease. We are trying to move files from the Samaba share to the windows drive. When we run a batch to move them the move completes but the final removal of the files from the Samba share do not...
We have a Samaba share set up on a Windows 2000 Server box and are able to browse the share with ease. We are trying to move files from the Samaba share to the windows drive. When we run a batch to move them the move completes but the final removal of the files from the Samba share do not...
I have a sheet set up witht he correct formulas and I want the way it is now if I use auto fill I get a bunch of divide by zero errors. The user will enter a new new line of data every week and doesn't need to see pages and pages of Divide by zero errors. Is there a way to have it autofill...
Here is what I need:
Anything in column A with a value higher than 80 then it takes the amount over 80 and multiplies it to column D to equal column E.
I tried the second formula but I need to give you more details. I over guessed on the number of values in my Rows.
Row A: 7109
Row B: 6923
Row C: 13747
Row D: 13973
The formula seemed to work but after Row A and Row B ran out of Data the True and false kept going. Do I need to just swap Row...
Here is what I have:
4 columns of data (50,000 Rows each)
I want something to search each 4 columns of data write a new list(column or worksheet) of the values that appear in all 4 columns.
Any ideas on how I can do this quickly?
I need some advice on the best way to transfer software between Symbol LRT3840's. I have several units and I need to copy the client software from one to another.
Thanks
I have found that our data connection speed was the cause of most of our problem. We went up to a Full T1 1.5Mbs and that took care of most of the lag. I did find though that the Wyse 3360se would not connect across the connection to use DHCP to receive it's address. That has to be done...
We have a very similar sittuation. We are trying to run a VPN between a Sonicwall XPRS2 and a Netgear FVS318 and it is teribbly slow. The sonicwall side is a Full T1 and the Netgear side is a 512K Down 128K up. I have a 10MB databse file that a particular program accesses. It takes a...
I have a Sonicwall XPRS2 an Neatgear FVS318 VPN tunnel that works for a regular PC running Windows 2000 pro. But when I put a Wyse 3360se on the Neatgear side of the VPN and tried to Remote Desktop to the Sonicwall side I get a slow response with a long delay after every key stroke. Again...
I'm trying to use a APC 8 port Share UPS expander with an APC Backup UPS Pro 1000. I plu git into the serial communication port but I don't get any power lights on the share UPS. Does anyone have any ideas on what I might need to get this setup working?
Does anyone know of a good way to block a handful of terminal service users access to a particular site or to give them acces to only one particular site? I've looked in Group Policy editor and really haven't founf too much.
Thanks,
Eric
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.