Concatenate with "

**excelaron** · 06-21-2012, 06:28 PM

I have a value in cell A1 = LocationList(1, 2) , B1 = (555) 549-6131

I tried CONCATINATE(A1,""",B1)

AND GET THIS RESULT = LocationList(1, 2) ",B1,"

**tigeravatar** · 06-21-2012, 06:34 PM

In Excel, a double quote " starts or ends a text string. If you want to inlude a double quote within a text string, you would start the text string, and then put in a double quote twice, and then end the text string with the double quote:
=A1&""""&B1

**excelaron** · 06-22-2012, 12:47 AM

My result should be LocationList(1, 2)= "(555) 549-6131"

**tigeravatar** · 06-22-2012, 11:17 AM

Alright, so here's what I imagine this setup looks like:
A1 contains "LocationList(1, 2)"
B1 contains "(555) 549-6131"

LocationList(1, 2)

(555) 549-6131

So to get a result your stated result of: LocationList(1, 2)= "(555) 549-6131"
The formula would be:

Please Login or Register  to view this content.

**excelaron** · 06-22-2012, 12:38 PM

I got the same result with the phone number format stripped - LocationList(1,2) = "5555496131"

I copy & paste your formula

**tigeravatar** · 06-22-2012, 12:50 PM

excelaron,

That just means you entered the phone number as a number without formatting in the cell, and then formatted the cell to display the desired format. You'll have to do the same in the formula using the Text() function:

Please Login or Register  to view this content.

**excelaron** · 06-22-2012, 01:31 PM

I twicked =A1&"= "&TEXT(B1,"(###) ###-###0")&""

Works perfect, thank

Can't copy and paste, I have different regions and many rows, before I had to do manually