Combining values in a range and converting to single string variable

**beat** · 01-30-2014, 08:01 AM

Hi,

Lets say i have different text values in range A1 to A10

I want to convert those values to a single string variable

eg

dim Combinedwords as string

Combinedwords = Range("A1:A10").value

Obviously that example doesnt work.

Thanks for any help you can provide.

Beat

**Olly** · 01-30-2014, 08:26 AM

Try:

Sub foo()
Dim Combinedwords As String, c As Range
For Each c In Range("A1:A10")
    Combinedwords = Combinedwords & c.Value
Next c
Debug.Print Combinedwords
End Sub

**beat** · 01-30-2014, 10:46 AM

Thanks thats perfect

Combining values in a range and converting to single string variable

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Combining values in a range and converting to single string variable

Re: Combining values in a range and converting to single string variable

[SOLVED] Re: Combining values in a range and converting to single string variable

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] NEED HELP with combining two cell string values and removing duplicate String values....

Extract multiple values from a single value that meet a single search string

Combining a table column with another range into a single array

Combining Multiple Range Values into a Single Array

Converting several columns containing lists of values into a single column

Bookmarks

Bookmarks

Posting Permissions