Results 1 to 18 of 18

Shorten my CONCATENATE formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-07-2007
    Location
    Singapore
    MS-Off Ver
    2006/2016
    Posts
    170

    Shorten my CONCATENATE formula

    I have the following:

    =CONCATENATE(B3,C3,D3,E3,F3,g3,h3,i3,j3,k3,l3,m3,n3,o3,p3,q3,r3,s3,t3,u3,v3,w3,x3,y3,z3,aa3,ab3,ac3,ad3,ae3,af3,ag3,ah3,ai3,aj3,ak3,al3,am3,an3,ao3,ap3,aq3,ar3,as3,at3)

    is there any way to shorten it?
    Last edited by lordfa9; 12-31-2014 at 12:40 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. way to shorten this formula?
    By tsiguy96 in forum Excel General
    Replies: 2
    Last Post: 04-03-2012, 08:28 PM
  2. can shorten this formula?
    By mingali in forum Excel General
    Replies: 4
    Last Post: 08-12-2009, 10:22 AM
  3. formula to shorten if need be
    By excellentexcel in forum Excel General
    Replies: 3
    Last Post: 03-04-2009, 01:50 PM
  4. shorten if and formula
    By Michael Wise in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-09-2008, 04:46 PM
  5. Shorten a Formula
    By Kevin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-29-2006, 10:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1