Yet another Excel question

Fiat Coupe Forum
- Founded by Kayjey & James Northam
- Funded by the Club for the benefit of all owners

Fiat Coupe Club UK

Fiat Coupe Forum

» Announced
Posting images

» Related sites
Main club site
fiatcoupe.net

» External data
owners listed

Top Posters(All Time)

barnacle 33,553

stan 32,122

Theresa 23,300

PeteP 21,512

bockers 21,071

JimO 17,917

Nigel 17,367

Print Thread

Yet another Excel question #1523365 26/01/2015 17:34 26/01/2015 17:34
E elder81 Unregistered
elder81 Unregistered E	I have a large number of rows with data that I would like enclose in speech marks. e.g. I have the word Banana and I want it to end up as "Banana". Concatenate gets all confused using the following formula: =concatenate(""",A1,""") As you would expect you end up with ,A1,. I have a work around using a single field with " then concatenating the multiple fields. Is there anyway it can be done with one formula and just the source field?

Re: Yet another Excel question [Re: ] #1523372 26/01/2015 18:37 26/01/2015 18:37
Joined: Dec 2005 Posts: 8,411 Lightwater, Surrey DaveG Club Treasurer Member 311
DaveG Club Treasurer Member 311 Je suis un Coupé Joined: Dec 2005 Posts: 8,411 Lightwater, Surrey	=""""&A1&"""" (4 double quotes either side) will work, as will =CHAR(34)&A1&CHAR(34) or easier to read: Code: =""""&A1&"""" =CHAR(34)&A1&CHAR(34) Last edited by DaveG; 26/01/2015 18:38. Reason: easier to read using [code] 1996 Portofino 20vt & 2000 Pearl White Plus 1985½ & 2016 2017 Fiat 124 Spider + XF Sportbrake

Hop To