Skip to main content

Bernd Oswald

Bernd Oswald's Public Library

  • nstead, we need to use a special function named CONCATENATE.
  • The parameters for CONCATENATE are simply the words we want to join together.
    • OK, that formula is a little hard to parse at first. If your building, street, and zipcode are in columns B, C, and D, then the above formula can be described, in English, as:

        
         
      1. Start off with the text in cell B2 (building)
      2.  
      3. Add an empty space
      4.  
      5. Then add the text in cell C2 (street)
      6.  
      7. Then add the literal string , NY , – a comma, then a space, then NY, which stands for “New York”, then another space, and then a second comma
      8.  
      9. Finally, add the text of D2 (zipcode)
      10.  
        

      After typing in the formula, the value under your column header of my_custom_column should be something like:

        
      56 COURT STREET, NY, 11201

2 more annotations...

1 - 20 of 4571 Next › Last »
20 items/page