Question from Sprout: Excel 2007, how is data/text 2 columns done when the text is very staggered from one vertical row to the next?
When I get electronic Excel documents the alignment of the text is very staggered. I would like to be able to easily seperate one column from the next and be able to do my work in a flash. I have not figured out a way yet though. Help 
Popular answer:
Answer by yogi_bear_79
I am not sure I follow your question but here is what I can make of it. You receive an Excel file from some source and all of the data is in column A. You would like to separate the data into multiple columns based on some factor, in this case it sounds like a space or a tab.
There are several ways to accomplish this within Excel. However what may be the quickest, is to copy the data from column A into a .txt document using Notepad.
Then open Excel, and use the Open button, browse to your .txt file (ensure you have changed the file type it is looking for at the bottom of the browse for window). Find the .TXTfile and open it.
This will open a wizard that will walk you thru opening a delimited file. There are several choice of delimiters or you can make your own. Select the one that is right for your file. It will show yo a preview of how your data will be separated.
This process is only as good as the orginal data. But most data is exported into a delimited format of some sort.
What do you think of this error? Answer below!
Question from july5_uk: Word 2007 page numbering problem?
I use Word 2007 and it’s bneen fine until recently. However…
when I insert a pagenumber now it displays on screen as (PAGE \* MERGEFORMAT) instead of showing the page number. It prints fine but it is a little annoying that it doesn’t display the number on screen on the page.
I think I must have ‘clicked’ somet option but cannot work out what I have to do to get it back to how I want it.
Any help would be appreciated.
Thank you.
Popular answer:
Answer by billybob2769
press Alt + F9
Know better? Leave your own answer to this error in the comments!
Question from Missy S: Downloaded free trial of Microsoft Office 2007 and I hate it How do I remove it and get me XP back?
I downloaded free trial of MO2007 and I hate it. The trial isnt up and I just want my Xp back. I have a dell and it came preinstalled onto my computer. Contacted Microsoft help and they wanted me to pay them a fee to contact there help. Dell did the same thing. Seriously Microsoft Office 2007 is a horrible program.
Popular answer:
Answer by Node1499
When you installed the trial, you were asked if you wanted to upgrade your installation or if you wanted a seperate installation.
If you chose to upgrade, once you remove the program using the Add/Remove programs in the Control Panel you’ll need to reinstall your other program. If you chose a seperate installation, just go to the Control Panel and use the Add/Remove prgrams to take it out.
Add your own answer to this error in the comments!
Question from nilufer: POWER POINT 2007 HELP.. 10 POINTS!!?
On powerpoint 2007 im trying to put a animated picture from google but it says this file does not support this program.. Why doesnt it work how can i make it work ?
Popular answer:
Answer by Penny
Are you saving the animated picture in the file extension that Google has it in? I’ve sometimes found this to be an issue. You might also go to Microsoft’s clipart gallery and use one of their animated pictures — also check the file extension to make sure the Google animated picture is the same extension.
Check out the Microsoft link below. Their animated pictures seem to be .gif files.
If you have a better solution to this error, please comment below.
Question from Rachel: how much does microsoft office 2007 cost with a student discount?
i just got a laptop and it came with a 60 day trial of office 07. i heard that you could get it with a student discount for an affordable price. im a student, and i cant find the price with the discount anywhere. can anyone help me? also, if you know the price of norton, that would be helpful too.
Popular answer:
Answer by ag
Your discount is different depending on what school you go to. You might also have to order the software through one of your school’s channels
Give your answer to this error below!
Question from Max H: How can I use the round syntax in Excel 2007 to round a formula?
The syntax is… =ROUND( Number, Num_digits )
I tried to put in this… =ROUND( 30/B2, 2 )
For some reason it’s coming up with an error, but if I work out the formula myself and put that instead of 30/B2 it works.
How can I make it work.
Popular answer:
Answer by archit
=round(formula),0
The zero at the end has to be replaced by the number of decimal places you want after rounding off.
Know better? Leave your own answer to this error in the comments!
Question from Misty T: Whats wrong with this resume?
MANAGMENT SALES,TECH,NETWORKING CALL CENTER, AND GENERAL OFFICE, HELPDESK
OBJECTIVE
“To obtain a challenging position in management/General Office that would best utilize my experience in the sales retail computer IT and office skills.
“Environment. This position should have many opportunities for an aggressive, dedicated individual with the problem
“Solving, leadership, and organizational skills needed to advance.
PROFESSIONAL HISTORY
Current Employer
Tiger direct
Business Account Manager
Business to business Sales
Meeting sales goals
Prospecting Client’s
Taking in/outgoing calls in a call center office setting.
Faxing quotes daily to clients.
Merchants Tire and Auto
3-2008/
“-Constant clear and concise communication with employees and management.
“-Analyzing problems and developing solutions within an appropriate time frame.
“-Performing services within the specified
Just Tires
Service Technician
2-2007/3-2008
“Constant clear and concise communication with employees and management.
“-Analyzing problems and developing solutions within an appropriate time frame.
“-Performing services within the specified
CompUSA Inc. Raleigh, NC (December 05 – November 06)
Technical Services Manager
“Opening and closing store responsibilities, including cash management for a
multi-million dollar store
“maintaining Profit & Loss statements for the entire technical services department
“Hiring, scheduling, training, and managing a team of 8-11 associates
“Ordering, sourcing parts, and communicating with multiple vendors
“Communicating and appropriately handling all customer issues, finding solutions to every problem
“Motivating sales, upgrades, and all other technical services in order to maximize
profit and sales
“Providing support for all store staff and equipment
Staples Office Supply Wake Forest/Cary, NC (October 03 -November 05)
Electronics Lead / Key Holder / Manager-in-Training
“Opening and closing store responsibilities, including cash management
“Keeps sales team motivated and assures employees that they are valuable members of the Electronics team
“Responsible for training and coaching associates’ behaviors to ensure maximum sales
“Reports to sales and general manager weekly numbers of planned sales and budget
Accomplishments
” As of May 2005, was the only employee to sell a Mobile Technology Plan
” Acknowledged by several customers for exceptional service to corporate office
” Exceeded corporate projected sales by over 50% during 2004 fiscal year
” Maintained in the top 3 stores in the district for sales of Cable, Ink, Paper and Service plans (CIPS)
Accelerated Language Academy Raleigh, NC (Jan 03 – July 06)
“Network Designer/Administrator and Graphic Design Artist/OFFICE EXPERENCE
“Answered in/outgoing phone calls
“Signed in new clients
“Maintained in/outgoing faxes
“Handled in/outgoing Mail
“Filed all documents in office
“Designed and installed computer network
“Made visits to maintain and upkeep network/servers
“Designed advertisements and brochures to increase involvement in the academy
“OFFICE ENVIRONMENT
Accomplishments
” Handled network troubleshooting for eleven computers
” Customized network to fit customers needs with minimal problems
COMPUTER SKILLS
“Microsoft Windows XP, Win 2K, Win NT, Win 98 SE, Win 95, DOS, Linux
“Microsoft Office 2003 Professional (Word, Excel, PowerPoint, Outlook, Publisher)
“Photoshop 7.0 Illustrator AS400 Symantec Products
“Panda Internet Security McAfee Products Lotus Notes
“Symantec Ghost
“Acronis
“Configure
“Linux/server
EDUCATION
“ECPI Technical College Raleigh A+ Certification (Pending) May-June 2005
“Wilfred Laurier University Kitchner, Ontario September 2001-December 2002
Popular answer:
Answer by Herbert
The first, most obvious, problem is all the mistakes in grammar and sentence structure; this will put off potential employers. Ask someone to correct your use of grammar. Also, the two extra objectives seem superfluous and a bit pushy: “should”. And, most importantly, a resume should be written for a specific job application in mind. This one seems to be too general.
Depending on the place you live, there are a lot of government funded services that will assist you with writing a good resume. I would make use of those, if I were you.
Also, visit the library and read a good modern book on resume writing.
I am not an expert, but I do have a lot of experience in writing resumes, and this one shows some fundamental problems.
If you have a better solution to this error, please comment below.
Question from Shauna: How to remove Restrictions on my Computer?
hello all, I am creating a website and i am almost done. I wanted to preview it but it says caanot complete action do to restrictions in affect on this computer. Please contact your system administrator. How do i remove those restrictions for Microsoft Publisher 2007, for Windows Vista? please help
Popular answer:
Answer by Einstein WhiteHatr
If you have the most privilege account and you control the command shell
If you have a better solution to this error, please comment below.
Question from Near: In MS Access 2007 form making/linking question?
I’m building a database that will be seen to the user as just a form. This is an employee evaluation form.
Right now I have 2 tables, one with employee information such as name, id number, phone number, etc and then another table consisting of communication questions the employee is supposed to answer. The form looks like a typical website with navigation on the side of the form, linking communication, teamwork,etc. In these sections are questions. So for example communication has 5 questions under it and teamwork might have 3.
the problem I’m having is that whenever I type in a persons information (Lets say Employee A) in the employee information table and click the link to navigate to communication it doesn’t record that information under employee A or anyone for that matter, its just kinda floating information. I made a relationship between the two tables I just don’t understand whats wrong.
How do i solve this to whenever i have a person type in their employee information and navigate to one of the questions it will be answered under their name?
edit: I probably should of mentioned in the Questions table the fields are the questions and so in the rows under the fields would be the answers. Would having an answers table be redundant if i did it this way? Also, Ultimately i want to have employee login names and passwords where they wouldn’t have to select their name from a combo box but the form would already married to their name once they logged in. This is what i’m trying to get working
Popular answer:
Answer by Andrew L
You need one more table “Answers”. This will have at least two fields, employee ID and question ID. Possibly also a text field for the answer. Your form is linked to this third table. In form design you add a combo box to the form. This allows the user to select their name, and it stores their ID in the Results table.
I strongly advise you to use Access’ built-in combo box wizard to guide you through this process. The wizard will ask you to confirm a series of statements …
“I want the combo box to look up values in a table or query”
Select the employees table, and select two fields – employee ID and name. The ID is the key column which will be hidden.
“Store that value in this field”
Select the employee ID field.
Go through the same process with your question ID.
You now have a form which the employee can use interactively, and the results are stored in your Answers table. They will select their own name from the first combo box, then select a question from the second combo box, and answer it. You need to work out where the answer is stored – this may be via another combo box, or just a textbox.
Give your answer to this error below!
Question from CH,Lim: Access 2007: How do I use DateAdd to get a date that hasn’t passed?
See, I’ve a database of insurance customers’ details. What I did, was asked customers how often they’d like me to update them on their policies (”Frequency”). I would then add this figure, which is in Months, to the date on which they applied for their policy (”StartDate”).
For example, if John had signed up on 30/1/2009, and requested I update him 3 months later, the next time I’ll need to call him (”NextCall”) would be 30/4/2009.
The problem now is, what about those policies that begun way back? Like say, 30/1/1990. If the customer wanted a update every 3-months, the date that would show up would be 30/4/1990, which has already passed!
So I really need a macro or re-querying script of some sort, that will add the interval (”Frequency”) to the (”StartDate”) repeatedly till it gets a date that is either today, or in the future, and constantly updates itself to display the upcoming date.
I’ve tried” >=Date()” and “NextCall: DateAdd(”m”,[Frequency],[StartDate])”, but as you can see, these queries can’t meet my requirements.
Any help would be greatly appreciated!
Thanks for the quick reply, but I’m not sure how to go about doing that.. would it trouble you to point me in the right direction please?
AnnivDate: DateSerial(Year(Date()),Month([PolicyDate]),Day([PolicyDate]))
n: DateDiff(”m”,Date(),[AnnivDate])
NextCall: IIf([n]>0,(Date()+([n] Mod [frequency])),(Date()+([Frequency]+([n] Mod [Frequency]))))
Can somebody please tell me where I’ve gone wrong? It doesn’t show up properly! Btw, i need everything in months..
Popular answer:
Answer by Colanth
In VBA, just keep running DateAdd until the date is greater than today – for each record, using its inception date and its interval. Then your database will be in sync with reality.
If you have a better solution to this error, please comment below.