Split cells across multiple columns
I have a long list of one word entries (over 1000 rows). I would like
to split this across several cells and could not find a way to do that in
Excel > Data Menu sections.
I see Data > Text to Columns but couldn't get it to work.
Would like to preferably split those across 5 columns, but I
wouldn't know how many rows it would require (need table to
I will be cut-paste those entries from notepad/textpad.
I wouldn't mind using MS Word if I can get that table contents filled.
You have one column of single text entrie...problem in use money files after change of hard disc
I have using money since 1990 with constant updates, my latest update was in
2005. Recently my hard disc crashed and I have to change for a new hard
disc, after install money, I was unable to open my money files which run
satisfactorily before the crash. When I try to run openthe file it always
says "the file is created by an older version of money, money will save a
copy of the file and upgrade you file for use by the program". Then after a
while a message apear saying that "money is unable to acess your file .....".
Can any one help me.
I have run the same file...Data query drive error
After running a sql qeury in excel 2002, receive a message
error with "\" character and the help info box
stating "driver error".
I couldn't find any difference with either X: or x: in any combination
within any test macro I have below.
The resultant NUL/nul depends on the last statement used -- TestStr =
Dir("X:\NUL") / TestStr = Dir("X:\nul") respectively.
The drawback is they cannot be used in a unified way -- not even with
It toggled on and off. Any comment will be appreciated.
(My target cell : C:\R_D\[ABC.xls]sheet1!A1 with phrase "Virtual Drive
Assignment Test" )
Dim TestStr As String
TestStr =...Hard drive space running low
My hard drive is running out of space and I'm trying to delete whatever I
can, however, I do not know if I can delete any of the following:
Microsoft Visual Studio Tools for applications 2.0-ENU
Microsoft Visual Studio Tools for applications 2.0- Runtime
Modem on hold
Picture gear 4.1 Lite
QuickStores Toolbar 1.0.0
Smart Sound Quicktracks for Premiere Elements 8.0
Tru Switch Wizard for AT&T members
Viewpoint Media Player
and a funny one: Microsoft Office XP Professional, but I have the Home
Any help will be ...compressed drive for exchange db and logs
Is it bad to have exchange databases and logs on a compressed NTFS drive?
On Wed, 27 Jul 2005 15:35:51 -0700, "tony" <email@example.com> wrote:
>Is it bad to have exchange databases and logs on a compressed NTFS drive?
...Deleting emails from the M drive
We have some synchronization problems with some of our laptop users that
have just switched to Outlook 2003. In looking at the differences in the
number of items on the server and the number of items stored locally, in some
cases there is a large discrepency. For example, in my Deleted Items folder
locally I have a few hundred items, but in the server there is close to
100,000! Obviously this has been going on for some time.
Anyway, I went to the server to look at the Deleted Items folder in the M
drive, and sure enough, there is close to 100,000 items in there. So I tr...importing personal settings after reformatting hard drive
I reformatted my hard driva and re-installed Outlook 2003.
I imported all folders in my old .pst file, but cannot
import my toolbar settings, rules, custom contact forms
Can someone help?
The *.pst only includes Personal Folder data (any emails or folders you had
in your personal folder). You would have had to use the Office "Save My
Settings" wizard prior to reformatting your hard drive.
"Spiv" <firstname.lastname@example.org> wrote in message
>I reformatted my hard driva and re-installe...when writing out a file from .net, when is the file created? after the bytes are all written to the hard drive or before the bytes are written to the hard drive?
when writing out a file from .net, when is the file created? after the bytes
are all written to the hard drive or before the bytes are written to the
...dead hard drive or is it video?
I turned of my computeras usual, but when I went to turn it on again,
only the fans came on. I can feel activity in the hard drive and it seems to
on and then off...no signal imput to my screen.
Can I use it on my friends computer as a secondary hd to try to retrieve
I think your hard drive is dead, try to buy a new one and it'll help you.
> I turned of my computeras usual, but when I went to turn it on again,
> only the fans came on. I can feel activity in the hard drive and it seems to
> on and then off...no s...Excel save to network drive issue
I have found several articles out at Microsoft related to
this issue but I am having a very difficult time finding a
solution. Here is the error in full that the user gets:
Your changes could not be saved to
'name of the file', but were saved to a temporary
document named '95430000'. Close the existing document,
then open the temporary
documetn and save it under a new name.
Microsoft articles: 214032, 291070, 291204, 271513
User is saving to a "home directory" that is configured in
his NT profile.
Microsoft states to check the file permissions. This user
...How to clone failed hard drive to replacement hard drive
Looks like my current hard drive has failed as when I try to boot, the load
page does not show the hard drive or the dvd/cd drive and hangs on that page.
I had previous problems in trying to boot Windows and the only way to get
past that problem was to boot from the installation disc and do a repair
install. That got the computer booting OK. I did a scan of the hard drive
and there were a few errors that could not be fixed and subsequently have got
to the stage that looks like there is a hard drive failure. This hard drive
does still sound OK, no noises coming from it.
Is ...Need to redownload/install after hard drive crash
My hard drive crashed and I'm in the process of reinstalling/rebuilding
everything, however I don't have a saved copy of Money Premium that I
purchased. I still have my emailed receipt and can provide proof of purchase.
How do I download my registered copy again?
Depends on the version, but if you bought the downloaded version of 2005 or
2006 see http://money.mvps.org/faq/article/132.aspx
Glyn Simpson, Microsoft MVP - Money
Check http://money.mvps.org/faq/default.aspx for tips and fixes for MS
To send Microsoft your product wishes see http://mo...Won't Initialize External Hard Drive
I am having problems getting Vista to recognize my Western Digital My
Book hard drives (both a 500 GB and a 1 TB drive). When I plug the USB
cable in it goes through the installing drivers and says it installed
and the device is ready to use. However My Computer doesn't show the
drive. Disk Manager tells me the drive needs to be initialized but when
I try to initialize the drive I get one of two error messages the first
says "Incorrect Function". I then tried using System Restore to reset
the computer to before the last Windows Update since the drives worked
fine in...Hard Drive full
I've noticed 2 of our locations have run out of disk space. Each computer has
an 80 GB HD. I looked around and found that the log_.ldf is over 20 GB and
keeps growing by about 1 GB per day!!! How is this possible and how can I
reduce the size of this file? How can this be prevented in the future?
The easiest thing to do is download and install SQL Management Studio
Express from Microsoft.com (if not already installed). Then use this tool
to connect to the database. If you right-click on the database and click
Properties. Click on the Options section and cha...Server 2003 slow copying from external drives
I just re-installed SBS 2003 when the drives in the RAID array failed. I
rebuilt it without a RAID.
I am experiencing excrutiatingly slow copying from external USB drives. All
Windows freeze while copying a large file (2GB+) from the external drive to
the C drive.
I have tried more than one external drive to eliminate drive problems as a
I have scanned the c: drive (chkdsk /R /X c:) for errors and found none.
Copying from internal drive to internal drive does not cause the freezing or
very slow copy speeds.
This is a Dell Poweredge sc420 with dual Hitachi 500...More free space on drive c is needed
I have a program that requires a substantial amount of free space on drive c
(system) during operation. Sometimes it exceeds the amount available.
Is there a way to increase the amount of drive c free space without
repartitioning? I have some free space on other drives and I am thinking
about this feature of mounting ntfs volumes.
How exactly is this done?
<email@example.com> wrote in
> I have a program that requires a substantial amount of free
> space on drive c (system) during operation. Sometimes it
> exce...Wiping hard drive on vista.
Hello my laptop recently got a virus off of a website thats security
certificate had ran out 2 days ago and it has downloaded many programs and
i wanted to know how to wipe my vista hard drive without a disc. The reason
i haven't got a disc is because my laptop didn't come with one, it just has
"Restore your computer without a disc using system restore" and when i
created a back up the virus then later deleted it. Any ideas?
This newsgroup is for questions about Access, the database product that's
part of Office Pro...Hardware With Silent Snapshots of Data Drives?
On a Windows 2003 Server with a a 1 TB D: volume, we store and run about
eight virtual machines. Currently we use a Dynamic volume to make a
real-time mirror of this critical volume to two different hardware RAID
volumes. What I would like to know is whether there is a
straightforward way we could additionally maintain "snapshots" of the
logical volume on a third RAID device, to guard specifically against the
nightmare scenario where an operator accidentally deletes the volume.
Currently we do backups of our virtual machines with a procedure something
like the follo...Network drive
Is there a function to show the actual network path of the mapped drive?
Unmapping is not an option as it is mapped by a number of users (all are
mapped to various letters)
Refer the below for a VBA solution
> Is there a function to show the actual network path of the mapped drive?
> Unmapping is not an option as it is mapped by a number of users (all are
> mapped to various letters)
Using blabla.Split(whatever) you can split up a text-line into its
constituent elements of an array (as you will know well), my question:
is there code to do the opposite, say after you have nullified one of
the elements of the array? Please give simple example, no reference or
On 22/03/2010 11:12, Zach wrote:
> Using blabla.Split(whatever) you can split up a text-line into its
> constituent elements of an array (as you will know well), my question:
> is there code to do the opposite, say after you have nullified one of
> the elem...Can't move split database.
I'm slowly coming up to speed on Access... but slowly. In Paradox, it was
possible to redefine the Work folder and move a database to a new location.
But I'm having trouble doing the same thing with Access.
I've recently split our database in preparation for multi-user support.
Before the MDB split, it was possible to copy the database from the network
drive to the local C: drive and use it on the C: drive (to allow other users
to use it for read-only purposes). Now, when we attempt to use it on drive
C:, forms continue looking to the network drive for their data. For exa...importing pst files into Outlook from data recovery after hard disk failure
My hard drive blew but luckily my computer tech was able to recover all
data onto our new hard disk. Unluckily [unwisely!] I had not made
recent backups of Outlook files at home [mail messages, etc.] like I do
We located Outlook pst files but because they are not " backed-up"
files can't seem to import them back into Outlook. [Outlook prompts to
shut down, send error report, etc.] Tech says this process is possible
on old OE but can't work out how to do it with Outlook.
Any ideas anyone?
It doesn't matter if they are "not backed up" files as you...Why is it so hard
to synch outlook over a network?
I tried to expoet my inbox as a .pst file - re imported the file onto
the reformatted drive and found that it hadn't saved / transferred the
inbox sub folders
If I could've synchronised over the network to my desktop - I'd would
have never lost the info.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
"zeroseven" <firstname.lastname@example.org> wrote in message
news:zeroseven.x1vza@outlookfo...Too hard to do?
Good Day, I have to take (certain) data from one sheet to another if a
particular cell is not blank dynamically.
F400 PROJ 8029 3/18/10 7.25 12
F400 ACT 8029 3/19/10 KF10-0005 EVANS 9 13
F200 PROJ 8726 3/24/10 7.25 10
F200 ACT 8726 3/25/10 KF10-0006 JOCHEN 13 19
D400 PROJ 62 3/12/10 7.25 12
D400 ACT 62 3/11/10 K10-0039 PALAS 14 20
D200 PROJ 4327 3/30/10 7.25 10
D200 ACT 4327 3/29/10 K10-0040 PALAS
This is what my rows look like.
First row is projected data (filled out ahead of the project starting)
Second row is actual data (filled out as the project progresses...