1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Excel Column of data place in one cell with "data", "data" results

Discussion in 'Business Applications' started by chudok01, Jan 19, 2011.

Thread Status:
Not open for further replies.
  1. chudok01

    chudok01 Thread Starter

    Joined:
    Sep 16, 2010
    Messages:
    201
    I have an entire column of data that I need in one cell. When combined I need each piece of data to be surrounded by " " and a , between each one.

    151
    183
    2001

    results = "151","183","2001"
     
  2. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    ASAP's "Merge row data" ("Columns and rows" category) will do 99% of the work for you.

    http://www.asap-utilities.com/

    (edit: "entire column" -- do you mean full from top to bottom? :confused:)
     
  3. chudok01

    chudok01 Thread Starter

    Joined:
    Sep 16, 2010
    Messages:
    201
    yes - I used this. It worked except that I had to add the " at the very front and very end of the data.


    Sub convert150Combine()
    Dim J As Integer
    If Selection.Cells.Count > 1 Then
    For J = 2 To Selection.Cells.Count

    Selection.Cells(1).Value = _
    Selection.Cells(1).Value & """,""" & _
    Selection.Cells(J).Value
    Selection.Cells(J).Clear
    Next J
    End If
    End Sub
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/975601

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice