Combined cells with comma and quotes
How would I write my formula to combine text from consective cells into one cell but have quotes around every phrase/text in a cell and a comma. example "blahblah", "blah", "Blahblahblah". Essentially what i am trying to do is create a CSV file from my excel sheet so i can import it into 1Password.
assuming data in cell A1, B1 and C1
and you wanted to combine into D1
=CHAR(34)&A1&CHAR(34)&","&CHAR(34)&B1&CHAR(34)&","&CHAR(34)&C1&CHAR(34)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
what does the 34 refer to ? and do i put double "==" in front of the formula?
char(34) is an inverted comma "
== no my poor typing
see edit
And how would I add and a space between the phrases in quotes? "blah", "blahblah"
just add the space after the comma before the "
=CHAR(34)&A1&CHAR(34)&", "&CHAR(34)&B1&CHAR(34)&", "&CHAR(34)&C1&CHAR(34)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks