Is there a way to use a quote inside of a concatenate
@concatenate(a2,"-Test"," "/U]);")
I get a syntax error - What I am looking for in this cell is
a2 = 12
12-Test");
Is there a way to use a quote inside of a concatenate
@concatenate(a2,"-Test"," "/U]);")
I get a syntax error - What I am looking for in this cell is
a2 = 12
12-Test");
The error is because of the " after test.
Try using =A2&"-Test"&CHAR(34)&");" to do this for you.
Note instead of using CONCATENATE you can join things just by using '&'.
If you have the same issues in the future because of a certain character then type that character on its own into a cell (say A1) and in another cell type =CODE(A1), this will give you the number to use within the CHAR function and can then be used in the same way as above.
Say thanks, click *
Try one of these...
=A2&"-Test"&""""&");"
=A2&"-Test"&CHAR(34)&");"
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks