Below is a short script that reads the names in selected cells, splits them into a last name and first-middle, and places them on the system clipboard. To use: Copy-paste into Script Editor; Select the cells with the names you need to 'split' Click the run button in Script Editor; Click once in the first destination cell in Numbers.
I am presently working in 'Numbers' with a transferred 'Excel' file. I needed to merge a previously split cell.
After doing so I noticed that the vertical cell dividing line is not perfectly lined up (however so slight) with the rest of the columns. I also noticed that 'Numbers' has created a new column but it is almost impossible to either 'slide' open the width of the column or to delete it. Is there a way to prevent these 'new column creations' or to be able to delete them and still retain the new vertical cell border? Thank you gaucho10. Yvan, I have a tax filing spreadsheet with 4 columns ('A' Date, 'B' Description, 'C' Rich, 'D' Janice). On the date column (A) I place the date of the transaction.simple. On Column 'B' I write down a description of what it is that I/we paid for.
As an example, last year my wife Janice bought a new car so I put the vehicle cost under her name in column 'D'. On several occasions it is necessary for me to include the price of an item under both of our names.
As an example we both pay for things such as electricity, fuel, television, etc. In these cases I would like to place the cost amount under both column 'C' and 'D' to show that we both paid. That keeps us from arguing, thus we have a happy marriage (smile).
In order to put that single cost under both columns ('C' and 'D') I usually merge the cells so that the amount shows directly in the center of columns 'C' and 'D'. Sometimes I have to change these merged cells and split them so that I can enter two different figures for 'cost'. Such is the case this year when my wife retired and now I have to pay for some of the items alone.
I was able to do just that with my previous 'Excel' program. The problem is that when I try to re-split the merged cells ('C' and 'D') with 'Numbers' the program created a new column. The results are as follows: I still have column 'A' with no problem. I still have column 'B' with no problem. I still have column 'C' with no problem.
But now I have column 'D' as a very thin line and all the information from column 'D' has been located in column 'E'. The top bar where I can drag and stretch the widths of the columns is ok for 'A, B, C and E' but I can not stretch column 'D' which is only about 1 mm wide.
Also the vertical line that separates cell 'C' and 'E' is slightly off center (possibly because of the compressed column 'D'. I I I I I I I A I B I C I I E I I I I I I I - On the above diagram the double vertical lines shows the location and approximate size of the 'D' column with the new 'E' column following. I hope this explains my predicament. Gaucho10 wrote: Yvan, Yes you are right. I actually took a 'Numbers' plain sheet and entered approximately 80 lines of information which I 'copied' from my original Excel file.
I then attempted to do all those switches which I previously mentioned and they all worked out fine. The Excel file did not 'truly' transfer. Just something to keep in mind after transferring files.
Nothing new in that. Several threads demonstrated that importing Excel documents may give defective Numbers documents. When I really need to open XL documents (most of them are directly moved to the trash), I use a true clone like neoOffice or neoOffice. Yvan KOENIG (VALLAURIS, France) mardi 18 janvier 2011 11:21:21. Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only.
Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site.
All postings and use of the content on this site are subject to the.
Separate First and Last Names in Excel To separate the first and the last name from a cell in Microsoft Excel, you can use a combination of a few functions. Use the “Left” function combined with “Search” function for picking the first name and forthe last name use the “Right” function combined with “Len” function and “Search” function. To separating names follow below steps in Excel:- Example: We have a list of names in Column “A” and we need to pick the First name from the list. We write the “LEFT” function along with the “SEARCH ” function.