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

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

chudok01

Thread Starter
Joined
Sep 16, 2010
Messages
204
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"
 

chudok01

Thread Starter
Joined
Sep 16, 2010
Messages
204
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
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Top