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 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.
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.
since 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 RelatedSo, 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 RelatedAs a writer, I'm going to be using Pages on my brand new MacBook Pro 13" (I just switched from Windows) quite a lot, so it really ticks me off that whenever I insert text in a line in a paragraph, the line below it gets separated from the rest of the text instead of simply moving the text on the line I'm editing smoothly into the following lines.
View 1 Replies View RelatedI want to sort out my finance spreadsheet where I have the category of the spending and the adjacent cell is the amount I spent.
[Category, Price]
[Gas , $50]
[Grocery , $80]
[Lunch , $15]
[Gas , $34.50]
What I'd like is for a function that can sort the categories into individual columns for the categories. So that this big list of purchases I have is sorted out into their own column that matches the category and then sums it too. Does this make sense? I was sort of avoiding any VBA for this but if thats how it has to be done then thats cool
Is there a way for me to find a page break and replace it with paragraph instead in Word 2008?
View 4 Replies View RelatedSo, 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 can't find the option to get rid of them. The first two, arrows and the dot. I only have 'Attachments', 'Date Received' and 'From' selected under 'View > Columns'.
View 2 Replies View RelatedLove it or hate it, I couldn't stand the all-gray iTunes and the vertical traffic lights. So I dropped a little script in the terminal and installed a modification to bring colour back to my icons. Now that iTunes 10.1 is out, does anyone have any experience with it breaking such modifications? I can't quite remember what it was I changed or I would experiment for myself. Unfortunately I'm tech savvy enough for basic trouble shooting and following explicit directions but not enough to know all the components of iTunes. I think I replaced a resource file of some kind.
View 6 Replies View RelatedEver since upgrading to Snow Leopard and using Apple Mail, I have been getting the following error after a day or so of use: "Account exceeded bandwidth limits." Eventually I am able to access GMail via IMAP with Apple Mail, but only for about a day before this error occurs again. This doesn't affect my access to GMail via the web interface. Nothing has changed with my use of GMail since before the Snow Leopard upgrade and I've seen scattered reports of this on the 'net, but nothing that nails down a solid connection between the Snow Leopard upgrade and this error.
View 15 Replies View RelatedFairly simple, I've added an automatic contents page to my document, but I was hoping to have it use two columns instead of one to conserve space since none of the headings are especially wide. However, when I change the number of columns, it screws up the contents, whatever is used to space out the titles and the page numbers doesn't seem to adjust automatically.
I'm wondering if anyone knows a way to do this without manually entering the contents?
I was wonder if there was a way to use both coverflow and 3 column view. I did search.
View 4 Replies View RelatedI just downloaded the new itunes 10, and the first thing I noticed was the "album by artist" column under the music library. I don't like it at all. I want to remove it, but I can't! I'm not talking about the "album artist" column. This is totally new with the iTunes 10. When I try to remove it by, it only gives me the option of sort and artwork.
View 5 Replies View RelatedAfter a few months mild use on OS X I'm starting to get used to it more and more now. I love the column view, but find it really annoying that occasionally new finder windows will open in Icon view. What exactly is the point of the finder preference "always open new windows in column view"? It sounds pretty straight forward, but finder doesn't exactly pay much attention to it. When I'm viewing in column view and I command-double click a folder, finder will open a new window in Icon view, depsite my preference. I have to reset the new window to column view and then close it, and then when I repeat the command-double click it will open in column view but it kinda defeats the point. I've read numerous posts about finder not remembering views, I don't understand also why there's only an option for column view? why isn't there "always open in list view" or "always open in icon view" option?
View 1 Replies View RelatedTwo emails in my mailbox have two exclamation points (!!) in the flagged column. I was unable to find what this meant in the help doc or on google. I was wondering if someone on here might know what this means. The two emails were sent via forms on my websites so I imagine maybe that has something to do with it? Anyway, any insight on these crazy exclamation points.
View 4 Replies View RelatedI have about 20 playlists. I want to apply the column formatting (including widths and orders) of the main itunes music library to these playlists. Is there a way to do this? I cannot do it manually.
View 12 Replies View RelatedDoes anyone know how to set all the folders in Outlook 2011 to show the same set of columns?
View 1 Replies View Relatedhow to change india numbers to arabic numbers?
Info:
MacBook
Pro, Mac OS X (10.6.7)
1. Turned the List Manager on by accident in Excel. Can't figure out how to turn it off now. I am using Excel 2004, and a MAC mouse - so no right-clicking for me...
2. How do I move columns in Excel? I select the column on top, but then try dragging it to a place I'd like it to move, but nothing happens. How do I do that?
3. General Mac Word/Excel question - how do I get to use "Home" and "End" buttons? When I hit them I simply jump somewhere, but not to the beginning or end of the paragraph. I have a MAC keyboard with the "Home" and "End" buttons along with the "Help", "Delete", "Pg Up" and "Pg Dwn" keys - basically it looks a lot like a PC keyboard...
I'm wondering if there's a way to eliminate the visual break in-between pages in Pages '09 (see screenshot). I'd prefer maybe a subtle dotted line indicating a different page, not a 5-inch gap.
View 1 Replies View Related