How to merge two or more columns in OSX Numbers

There will be occasions where you will want to merge two columns in numbers. Like

  • Merging two columns with base url and image name to get the full image path.
  • Combining first name and last name columns to get the full name.

There can be several other cases. Recently I exported list of emails which had separate columns for first and last names. But my newsletter software wanted them as name,email. So I had to merge the first and last name columns with a space in between them.

Here is my list, which has 3 columns, first name, last name, and email.

Merging columns in MAC Numbers

I want to merge first name and last name into one. Here are the step by step instructions to do it

  1. First create a new column, say D.
  2. Select an empty cell in it and click the fx(formula) button in the menu.
    Creating Formulas in Numbers
  3. Then enter the formula (It should look like the screenshot below) and hit enter.
    Merging-Two-Cells-in-Mavericks-Numbers
  4. Tadaa!!, One row is merged. Now to merge all rows, copy the contents of this cell (cmd+c) and
    and select entire row D and paste(cmd+v)

    Copy the selected cell (cmd+c) and the select entire column by clicking on the column letter and press cmd+v
    Copy the selected cell (cmd+c) and the select entire column by clicking on the column letter and press cmd+v

Now we have the column we want but, what if we don not want the original columns?

You may think that you can simply delete them, but you can not, as our new column D is dependent on A and B. If you make any changes to A and B they will be reflected in D to.

So, export the sheet as CSV, and open this file and now you will be free to delete the source columns in this new file as the columns have no link to others. 

 

 

How to Receive Files via Bluetooth on Mac From Android and Other Phones

Receive-Files-via-bluetooth-on-OSX-Machines,-iMac,MacPro,MacMini

If you are able to send files from your Mac to other devices and unable to receive the files from them even after pairing, the most likely reason is your bluetooth sharing isn’t turned on.

Turn on bluetooth sharing on MAC OSX?

Turning bluetooth sharing is very simple.

Open preferences panel and select sharing and then select enable bluetooth sharing.  You will now be able to receive files via bluetooth on mac.

You can find the screenshots for the process below.

Note: Either  turn off bluetooth sharing when you don’t need it or make sure you have “Ask What to Do” selected for both receiving files and when other bluetooth devices try to browse your Mac. If you are not careful, people can use this to install spyware or other malicious software or get access to your personal files.

Be sure to pay attention to options marked with red arrows.
Be sure to pay attention to options marked with red arrows.