I have a column that has name / phone and i'm trying to break out the two into two separate columns. I can't figure out a way to do this? I'm trying to figure out to use the line break to trigger the column separation but no luck? Here is an example of what i have in a column:
Joe Blow
888-888-8888
I have a column that has name / phone and i'm trying to break out the two into two separate columns. I can't figure out a way to do this? I'm trying to figure out to use the line break to trigger the column separation but no luck? Here is an example of what i have in a column:
Joe Blow
888-888-8888
I'm planning of sending in my white macbook to AppleCare for a few repairs regarding the white casing (cracks) but do not want to send in my Western Digital 500GB Hard Drive.
I called AppleCare and they said they prefer it when you send in the original hard drive, for whatever reason they stated. My personal reason why I don't want to send in my 500GB Hard Drive is that I have a ton of files in there that are important and don't have another 300+ hard drive lying around to back everything up. Another reason is that my Leopard Family Pack disc I purchase years ago is at my parent's house in New York and I live in California, so getting it would be a huge hassle considering it's somewhere in boxes of storage and my folks are in Venice till the 15th of June.
Look, essentially what I'm freaking out over is that I've heard many cases that when you send in your computer to applecare, its not uncommon to get a macbook back with an erased hard drive.
I just don't wanna deal with the hassle. So am looking to avoid it altogether. Doing so bytaking out my 500GB HD and popping in the original 80GB HD that the Mac came with. I thought I had Leopard in there but when I put in the 80GB HD in the Macbook and turned on the Mac, a confused faced folder came on and turned off.
I want to send in my Macbook with the 80GB HD and that HD to have Leopard on it...so I decided to do the same method I used when I transferred everything from my 80GB HD to my 500GB HD when I first purchased it.
I used SuperDuper! application, free version...but it didn't work.
I set it up to "Copy: Mac HD to Untitled" (Untitled was the name of the 80GB since I erased it when I got my 500GB HD hoping to use it for Time Machine but never did)
I tried this twice, each time taking about 2 hours to transfer and copy to the untitled HD. I tried "back up all files" & "back up user files." But after this process was done and I popped in the untitled HD into the Mac I continued to get the same confused folder face..twice.
Any help on the matter is really appreciated as I'm highly considering not even sending my Macbook in with the 500GB HD to completely avoid any possible frustation if that HD was to magically erased.
I'm sure this is easy to answer by someone with basic spreadsheet skills, which I lack... I have a column of numbers (miles) and a column of use (Personal, Medical, Business). How do I set up 3 formulas so that I get the sum of the mileage column for each of the Personal, Medical, and Business categories?
View 2 Replies View RelatedI've been ripping my hair out trying to find the answer to this.
In Numbers for Mac, I need to fill a column automatically with a series of integers (1 - 50) and then the next column with a function that interacts with the first column.
For example:
Column A - 1 - 5
Column B - (value in Column A * 5)
I can't figure out how to do it in Numbers When I try to fill column a with 1 - 50 all it does is fill all 1's and I cant find an option how to make that change so it automatically numbers when I highlight them.
The best I can describe is how in Excel you can type 1 in the first cell, then highlight a bunch of cells and the little box appears that lets you click "Fill Series"
In Numbers '08, is it possible to link cells/columns between sheets; so that in the below spreadsheet selecting an item from Column A in "Hub Dimensions" sheet in the drop down box of the "Spoke Calculator" sheet would fill out the cells in Column D of the "Spoke Calculator" sheet with data from the related cells in the "Hub Dimensions" sheet?
View 1 Replies View RelatedI have a .txt file that is quite long and I need to get some data off of it. The file is made up of a few thousand lines each with a format similar to: 1 2.4 5.4 abcde abc.def, The 1, the 2.4, the 5.4, etc each signify a different value and I need to somehow get them into separate columns into excel. The number of digits in everything except the first value (which is always one digit) varies, and all the values are separated by spaces. What is going to be the easiest way for me to get these values into numbers in separate columns? Realistically, doing this manually isn't an option.
View 2 Replies View RelatedI'm trying to "lock" or "freeze" the first column in the spreadsheet I'm making so that it will always be on the left side of the sheet when I scroll right. I cannot for the life of me figure out how though.
View 5 Replies View RelatedI'm new to iworks and have trying to figure this one out for a while. I used a template to set up financial info and calculate how much was spent on items. This was the preset formula: =SUMIF(Transactions :: $Category,A2,Transactions :: Amount)
However, I only want the sum from a particular range of dates (e.g. 9/1/09 to 9/30/09, as in cells B2:B10) so I can budget accordingly. In excel, you just grab the highlighted corner and drag it to where you want- here I can't do that and it won't let me add any more "conditions". Any idea how to remedy this? It's driving me nuts. On a side note, I am NOT a programmer so programming language will unfortunately not help unless you get VERY specific about how to do it (which you probably don't want to do).
Actually I would have to obtain a database of about 30 - 40 columns in a fixed order to come. I received many different databases, some fields such as street-houseN/boxN or names of persons in 1 field or multiple fields. (Depends on how the company keep track of data in a database)I would now systematically change databases automatically with applescipt and convert to all databases to the fixed database structure that includes all fields separated. How can I split 1 column in 3 columns?I have a tab delimited file with 1 column NAME (first-middle and last name in same field) but I need 3 columns.So I need it separated.If possible It would be great to just see for the column names.So the start file (select file) and see for column NAME.
So watch for the column NAMEÂ and make a new tab delimited file with 3 columns.FIRST NAME/ MIDDLE NAME/ LASTNAME as column names.Select file (tab delimited- mac roman)see for column NAME make new file in same directory with (_spit) in file name With 3 columns FIRST NAME/ MIDDLE NAME/ LASTNAME...The first word is the first name - the last word is de last name - the middle word or words are the middle name.When only 2 words in NAME FIELD > first name and last name.
I'm trying to create a template for legal billing. The only thing I'm really having a problem with is the formula that multiplies time by hourly rate. The time spent cells are formatted to show it as 4h 5m ... and that totals perfectly with the SUM formula. When I multiply it with a rate cell formatted to currency the math is fine, but the format stays as 00h 00m ... even when I format that cell to currency.
I made a task list in numbers. The font on the list is Helvetica 12. Now, the paper I am printing it on is 5 x 8.5 that fits in my notebook.
When I print the fonts that come out are very small. I have tried everything but nothing works. How come I don't get a what you see is what you get page?
i have the harry potter movies 1-6 in my itunes library and they are not in order according to how they were made....like it goes the second one, then the fourth is next to it, etc..... so its organizing alphabetically which is fine....but is there anyway to organize them according to movie 1, movie2, etc.
View 10 Replies View RelatedI just recently started using a Mac and I have a simple question I couldn't find over the net.How do I send the break key in Mac? For example in terminal, if I typed a long line but want to abort it, I used press Ctrl-C to cancel it in a different OS. Or if there is a console application, I press Ctrl-C to force the application to close.
I checked websites which told me to use the following:
command key + C - doesn't work
(I tried shift + command key + C, it also does not work)
alt + F3 (I pressed shift, option [for alt] and f3) - all my windows spread apart from each other
option + F3 - Expose & Spaces configuration window appears
I have a macbook which is about a year old; running really slowly, so bought 4GB RAM from crucial to install in it- the memory showed up, computer was soo much quicker etc . Working absolutely fine for a week, and now (as per the other posts by people in a similar topic) my computer is displaying the following:
The computer boots up, but within about 10 minutes, apps (especially Safari and MSOffice ) keep freezing and then I get the "please restart your computer" message.
Occasionlly I get loud beeping with a blank screen & flashing LED
Any help would be much appreciated; I'm now about wary about checking the RAM out or anything like that. Also.. because I installed the RAM myself, does that invalidate any warranty / Apple after care??
I changed a .dwi (UNIX EXECUTABLE) to a .txt so I could edit it. I should be able to change it back to a .dwi, but it wont let me (just stays a text document)
View 1 Replies View RelatedI've had my original MBP since 2007, which was originally on 10.4 I believe. I've done upgrades up to the current 10.7.4. My original MBP was encountering end-of-life hardware issues, so earlier this year ago I purchased a new MBP. I used the Migration Assistant utility to move my files and user settings.My older MBP toward the end of its life was having OS shutdown / reboot problems. The OS would never completely shut down. It would go to a light gray screen, and the twirling icon in the middle never went away. A manual shut down from the power button was the only recourse.It seems that the problem is tied to issue(s) with my user account settings, since the problem is still present, despite newer hardware.
After I do a manual shutdown/restart, I can immediately perform an OS reboot just fine. But after the OS has been running for hours/days, I can't run a clean shutdown/restart.I'm 100% confident that this is not a hardware issue. I'm comfortable with reviewing my system.log in Console and issuing Terminal commands, if that will help with any troubleshooting.
Info:
iPhone 4S, Mac OS X (10.7.4), MBP, 2.4 GHz Intel Core i7
See above title. i get that there's the "degree(cell)" function, but there has to be an easier way to change the settings so you can just input in degrees rather than radians.
like how calculators have a degrees and radians mode, i find it so hard to believe that there isn't one in numbers. if there really isn't, this is an incredibly flawed program.
How can I change the location of files created with the screen grab features of OS X Snow Leopard ? I tried to play with the "Keyboard" control panel, but I'm always getting an error when I try to capture a screen picture (something like : "can't write file to the specified location"). I really don't know what is that "specified location" and how to change it. Any idea ?
View 3 Replies View RelatedI have a new MacBook, 2.4GHz, 2 GB DDR, that has replaced my iBook G3 after the HD went out. May it RIP. Sometimes when I close the lid at work and put it in the computerbag it will be quite warm when I get it out. Sometimes it won't come out of sleep and I have to do a hard boot. What causes this and whats the remedy?
View 4 Replies View RelatedI have a MAC OS X 10.4.11 IBook G4 1.1. It's acting up on me. Crashes often and freezes as well. The only CD I can find is the Mac OS X Tiger Install DVD. Is this the Hardware test cd as well?
If yes, how do I get the hardware test started. I tried the "restart while holding "C"" and "restart while holding the "option key""... Doesn't work... Don't see a hardware test option. If no, Can I download the application
I have an old 867 Mhz G4 MDD that I would like to be able to leave running 24/7 as a server, jukebox etc. Right now it's noisy (these things are legendarily loud) and power hungry. It won't have to work very hard. What could I do to make it efficient and quiet enough to run 24/7, without dumping a lot of $$$?
Obviously what I really need is a mac mini, but this will have to do.
I get the following message frequently: "The operation couldn't be completed.Operation not permitted.(NSPOSIXErrorDomain:1)".I need to restart the computer inorder to access the internet.I connect via wireless and other wireless items on the network don't have this issue.
Info:
iMac, Mac OS X (10.6.8)
I have a question that was sort of touched on in mac forums but never solved for someone else back in 2007. I have been scouring the net to find a remedy to my problem. I have mac os 10.4.11. I have a zipped file (final cut pro) that i am trying to open and when I try to open it i get a "unable to unarchive (error 1 - operation not permitted)" message. I followed the guidelines from the old thread for the other personIi repaired permissions but when I tried to download onyx it told me the the onyx version needs a higher OS (10.5 I beleive) than I have and other efforts to find the onyx for my mac have failed. I have also downloaded x slimmer and Xserve raid driver for people that use final cut pro.
View 11 Replies View Relatedsince I don't know when, the columns in Finder windows have always the same size. If I change the size, and then close the windows, when I open a new one, the column get back to their "original size" (which is too small for my personal use).Â
View 2 Replies View RelatedI have MacBook Pro, i have leopard running on it, when i try to install Snow Leopard on it, it gives an error!!!Operation could not be completed. (OSProductManagerDomain error 100.)This error pops-up when i double click on "Install Mac OS X".
I tried running Disk utility and repair permissions. Restarted my MacBook, pressed "C", no luck...
I am not able proceed further... Please any help would be great...
About 2 weeks ago suddenly Finder are unable to sort files in alphabetical order in Column mode.About the same time when my external HDD died (don't know whether this has any effect).Â
Sorting by name works fine in icon only mode, but whenever I switch to Column mode its completely disorganized.And when I tried in coverflow mode its alphabetical but in inverted mode (Z to A).Â
Info:
MacBook Air
im running mac os x 10.4.6 on a g4 powermac. ive got toast 9, but whenever ive tried to burn a cd, it gives me the following message " sense key = illegal request sense code 0 x 20 invalid command operation code" and then "couldnt set up the track for writing"
although I have been successful in burning a cd from itunes. im guessing its something to do with the settings, but im completelyey stuck.
So, I'm still new to the whole Mac OS X happening, just got my MacBook about three of weeks ago (very happy with it ^__^). But, there's this little problem. I'm now using Microsoft Office 2008, and I often use Page Breaks. Previously, on the windows computer I used, I could simply press ctrl + return to insert a page break, but this is not a standard shortcut in the Mac version.
My solution - or at least, I hoped it would be a solution - was to use a custom shortcut for Microsoft Word via the System Preferences. I would like to set it to either ctrl + return or cmd + return, but it doesn't work.. However, when I try a shortcut like ctrl + cmd + down - or really anything without the return key - it works just fine. So, here comes the actual question; Is there any way to incorporate the return key within the shortcut?
Ohh, and now another problem comes in mind, I've got this Video_TS dir on my HD from a dvd which I tried to open, but when it's opened it simply 'plays' the menu. So I'm unable to actually select the option from it, and it simply goes to other part - like chapter selection - afterwards.It also plays little bits of the files, hangs for while, and skips a bit, then repeats the cycle.Anyone familiar with it? I use VLC Player Open Disk... with the Video_TS folder option.Ohh, and the files play fine on the windows pc next to me.. I realise this last question maybe should be in another topic, or has already been answered somewhere on the forum. But I did do a search for the first one, and couldn't find any information on it.
I got a 6gb file I need to send to my other computer since its I cant get the network configured and its too big for a dvd. Files that big wont be sent over aim or anything really. How on a mac I can break it down into smaller files? Its a .iso
View 3 Replies View Related