+ Reply to Thread
Results 1 to 4 of 4

Combining columns while adding piece of data between them.

  1. #1
    Registered User
    Join Date
    09-23-2008
    Location
    Ohio
    Posts
    13

    Combining columns while adding piece of data between them.

    I have 2 columns of data, ( quite a few thousand lines). what im trying to do is combine two of them and add a comma and a space between what the two pieces of data had in them.
    example

    column d has the word Chicago in it column e has the word IL in it

    the end result to be in column d as Chicago, IL (just as an example)
    i have tried to write an if then statement to do this, but come up empty handed, has anyone successfully done this that can point me in the right direction.
    thanks in advance for your help
    james.

  2. #2
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626
    Two formula can do

    Please Login or Register  to view this content.
    I need your support to add reputations if my solution works.


  3. #3
    Registered User
    Join Date
    09-23-2008
    Location
    Ohio
    Posts
    13
    That works good for just 2 cells, but how can i apply it to all of both columns?
    thanks, james

  4. #4
    Registered User
    Join Date
    09-23-2008
    Location
    Ohio
    Posts
    13
    that was a dumb question, i think i got it
    thanks again for your help
    james

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combining data from 2 worksheets into a single data source
    By skerdoba in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2008, 06:38 PM
  2. Adding new columns from another worksheet
    By tame9cruet in forum Excel General
    Replies: 0
    Last Post: 01-19-2008, 02:06 AM
  3. Coverting Multiple columns of data into 3 columns
    By carricka in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2008, 07:26 AM
  4. combining columns
    By iznogud in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-23-2007, 04:51 AM
  5. Many Ols Regressions on Many Columns of Data
    By Carpenter9 in forum Excel General
    Replies: 0
    Last Post: 09-12-2006, 02:32 AM

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