SQL Query and parameters

My question is related to populating my SQL query values from Excel/VBA. In my query I have two types of inputs, one for a date, another for a city or list of cities. The date is working just fine and is populated in Excel as 'YYYY-MM-DD. I can do the same with a single city as 'MIAMI. What I can't figure out is how I properly populate multiple cities. The SQL which works fine in SQL Assistant would normally just read as ...in('MIAMI','CHICAGO') but from Excel I've tried all combinations of single quotes before and after, with/without comma separation, no quotes, no commas, etc. Any idea what the Excel format should be for this?

...

and ca.enddate>=CAST(? AS DATE)

and ta.targetingvalue in (?)

I am trying to do this two different ways. I have either one cell with MIAMI, CHICAGO, DALLAS and in sql I have a ? to trigger a parameter to look at that cell. Or I have one city in one cell and another city in the next cell etc. Then in my SQL I have a ? to look at that parameter. It pulls in the one value ok, such as Miami, but if I have all three cities in the one cell it comes up with an error [Teradata][ODBC Driver] Character string truncated. Then if I try to set the parameter up to multiple cells, in my excel, it says a parameter can only be one cell.

Trying to figure out how I can get those cities into my Sql to run the query correctly to pull back the numbers for those cities.