| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 35791 | 2003-07-21 23:53:00 | a quotation mark (") in an excel formula | Mike (15) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 161885 | 2003-07-22 21:45:00 | how about using tripple "'s as in: =concatenate("""text field """,a1,b1," ",c1) |
wuppo (41) | ||
| 161886 | 2003-07-22 22:36:00 | > how about using tripple "'s as in: > > =concatenate("""text field """,a1,b1," ",c1) Although that works around the text field, it doesn't when trying to apply it to a cell reference such as A1 (eg """a1""") - this treats A1 as a text field, so the result is "a1". Mike. |
Mike (15) | ||
| 161887 | 2003-07-22 23:00:00 | I used: ="text field"&(A1&B1)&"text field"&(C1) Is this what you're looking for? |
Capt Jimbo (17) | ||
| 161888 | 2003-07-22 23:15:00 | Oops should be more like this :-) =""""&(A1&B1)&""""&(C1) |
Capt Jimbo (17) | ||
| 161889 | 2003-07-22 23:25:00 | > Oops should be more like this :-) > > =""""&(A1&B1)&""""&(C1) Ah that works! Thanks Capt Jimbo, and everyone else for your suggestions. Mike. |
Mike (15) | ||
| 1 2 | |||||