Closed Thread
Results 1 to 29 of 29

CONCATENATE adds quotes - How to suppress?

  1. #1
    Registered User
    Join Date
    05-24-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    41

    CONCATENATE adds quotes - How to suppress?

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    I store my Bookmarks in this format . . .

    If I have the word "Description" in one cell, and a URL in the other, and then CONCATENATE them . . . =CONCATENATE(R2 &" . . . "& S2)

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    1.) The word, and no second line within the word cell, quotes or no quotes around the words, concatenates fine:

    "Description" . . . https://www.google.com/

    Description . . . https://www.google.com/

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    2.) If there is a hard return (Alt+Enter) within the word cell, and something else on the next line(s):

    a.) It puts another pair of quotes, around the quotes
    b.) It puts the whole thing in quotes

    Is there a way to keep it from doing this?

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    =CONCATENATE(R4 &" . . . "& S4)

    """Description""

    Description . . . https://www.google.com/"

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    "Description

    Description . . . https://www.google.com/"

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: CONCATENATE adds quotes - How to suppress?

    Try =R4&"description"&S4 instead
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    05-24-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: CONCATENATE adds quotes - How to suppress?

    Nope, that misses it.

    The above issue happens when:

    a.) you use a hard Return (Alt+Enter) within the description (and put something on a row below) . . . it puts quotes at the beginning and end of the Concatenate, and

    b.) if you use quotes within a description that has a hard return . . . it puts another set of quotes, around the quotes

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: CONCATENATE adds quotes - How to suppress?

    You might post a workbook and explain by example.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: CONCATENATE adds quotes - How to suppress?

    I think what SamboKid was suggesting was trying it without using Concatenate, i.e. just this:
    =R4 &" . . . "& S4

    Unfortunately, neither your formula nor the one above give me the 'extra quotes' problem you're seeing, so it's a bit tricky to help. I suggest trying to narrow down the problem as much as possible. If you try it without the second cell does the problem still occur? That is:
    =CONCATENATE(R4 &" . . . ")
    Or even with just the first cell and no dots?
    =CONCATENATE(R4)

    If the problem still occurs, then the only solution might be to replace all your line breaks (Alt-Enter) with spaces instead. You can do this with Ctrl-H (which opens the Find-and-Replace window). In the 'Find' box, hold down Alt and type 0010 (using the number keypad). You won't see anything appear, but that enters a line break in the 'Find' box. In the 'Replace' box, type a single space. Then click 'Replace' or 'Replace All' (depending on whether you want to check each one or not). You might find yourself with some double spaces now, but you can get rid of these by repeating the above with a double space in the 'Find' box.
    (Note - if you have line breaks elsewhere which you want to keep, select just the range you want to 'fix' first.)

    Hope that's of some help.

    Regards,
    Aardigspook

    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
    You don't need to give me rep if I helped, but thanks are appreciated.

  6. #6
    Registered User
    Join Date
    05-24-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: CONCATENATE adds quotes - How to suppress?

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    Please see attached xlsx file . . . This is how I keep all of my Bookmarks. It makes it easy to share things with others.

    When you copy and paste from the "C & P" column into Notepad++ or Notepad, you get:

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    AA - ok

    Google . . . http://google.com/

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    AB - ok

    "Google" . . . http://google.com/

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    AC - quotes are at the beginning and end:

    "Google

    row 3 . . . http://google.com/"

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    AD - quotes are at the beginning and end, and two more quotes are around the quotes, around the word:

    "Google

    ""row 3"" . . . http://google.com/"

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    C and P.xlsx

  7. #7
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: CONCATENATE adds quotes - How to suppress?

    How about changing the formula to

    =CONCATENATE(SUBSTITUTE(R2, CHAR(10), "") & " . . . " & S2)

  8. #8
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: CONCATENATE adds quotes - How to suppress?

    I'm afraid the extra quotation marks don't appear when I open your file, so it must be something in your settings. What happens if you try using Substitute to remove the line break?
    =CONCATENATE(SUBSTITUTE(R4,CHAR(10),CHAR(32))," . . . ",S4)

    Also, I've just spotted that you're not actually using Concatenate, as you're only using one 'text' within it - try replacing the & with commas - see if that makes a difference. That is, instead of
    =CONCATENATE(R4 &" . . . "& S4)
    use
    =CONCATENATE(R2," . . . ",S2)

    Regards,
    Aardigspook

    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
    You don't need to give me rep if I helped, but thanks are appreciated.

  9. #9
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: CONCATENATE adds quotes - How to suppress?

    Quote Originally Posted by Aardigspook View Post
    you're not actually using Concatenate
    Completely missed that ...

  10. #10
    Registered User
    Join Date
    05-24-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: CONCATENATE adds quotes - How to suppress?

    shg, I'll take a look at that thanks

    - - - - -

    Aard:
    In the spreadsheet is a column on the right, with the header: C & P
    "C & P" stands for "Copy and Paste" - This is what I use as output from the spreadsheet
    If you do a Ctrl+C on those four concatenated items under C & P, and paste it into Notepad++ (I use this) or Notepad,
    I think you'll see what I'm talking about (I show it, above, if you don't).
    If you just paste the text below in the same spreadsheet, you don't see it - Excel does something.

    I don't need to use the ampersand at all with Concatenate?
    . . . you learn something new every day!
    I see that I didn't in the Sort formula to the right.

  11. #11
    Registered User
    Join Date
    05-24-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: CONCATENATE adds quotes - How to suppress?

    Ok, here's something:

    I use Notepad++ Portable . . . http://portableapps.com/apps/develop...padpp_portable

    . . . because there is no export feature for your Notepad++ settings on the regular, install version.
    With the portable version, you just make your settings, and can then copy and paste the program to use anywhere as a stand alone text editor.
    The only downside to this is that I don't think you can update the portable version, due to some security risk.

    . . . so, I see that if I copy and paste the 3-row output into Notepad++, it includes the hard returns (Alt+Enter)

    . . . this is in contrast to if I paste the 3-row output into MS Notepad - it gets rid of the hard returns (so you wouldn't see the above if you were using MS Notepad)

    Also: I see that MS Notepad still adds quotes - so it's not a Notepad++ issue:
    a.) at the beginning and end of the entire concatenate, and
    b.) around quoted words within the description

  12. #12
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: CONCATENATE adds quotes - How to suppress?

    Hi,

    Now I understand the problem. I thought you meant that quotation marks were appearing in Excel, but you didn't - they're appearing in Notepad when you copy and paste from Excel. That makes sense, because Notepad can't parse some non-printing characters such as hard line breaks, so it adds quotation marks to ensure that a block of text is marked as belonging together.
    The only way I can see to stop this happening is to remove the line breaks before the copy and paste. You can do this with Substitute (changing each line break into a space) or with Clean (removing all non-printing characters). Each has its advantages and disadvantages. Substitute might give you two spaces sometimes but will always give you a space; Clean will remove the space entirely, thus often running words together - it might also remove things in Excel which you don't want removed.
    The formulae would be:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    or
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    or (if you only want to clear non-printing characters from column R)
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    The results are:
    Substitute:
    Google . . . http://google.com/
    "Google" . . . http://google.com/
    Google row 3 . . . http://google.com/
    Google "row 3" . . . http://google.com/
    Clean:
    Google . . . http://google.com/
    "Google" . . . http://google.com/
    Googlerow 3 . . . http://google.com/
    Google"row 3" . . . http://google.com/

    If you specifically need to use Concatenate, you could use Substitute or Clean within that formula.

    Hope that helps.

    Regards,
    Aardigspook

    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
    You don't need to give me rep if I helped, but thanks are appreciated.

  13. #13
    Registered User
    Join Date
    05-24-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: CONCATENATE adds quotes - How to suppress?

    The thing is, you want to keep the carriage returns, and just get rid of the quotes.

    If you copy and paste from Excel into Word, that gives you the correct output. You can then copy and paste it from Word to wherever you want, like Notepad, or Notepad++.

    So the question is, what is Word doing that it can handle this - getting rid of CSV characters . . . how does it do this?

    I see that there are a lot of question on this out there. I have the question in to Notepad++, as to if it has a setting, or if there is a plugin:

    https://notepad-plus-plus.org/commun...t-extra-quotes

    I know that when you export from Excel, you can set text delimiters. No changes there would help in this situation of copy and paste . . .

    I wonder if there's a setting in Word that if you un-checked it, then you would see the quotes. That would indicate how it's currently doing what it does correctly.

  14. #14
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: CONCATENATE adds quotes - How to suppress?

    If you use 'Paste Special' to paste unformatted text into Word, you'll get the same quotation marks as you get in Notepad. Essentially, any program which can't handle formatting marks / non-printing characters will give you the same result - by choosing 'unformatted text' you can force Word to behave like this too. The default paste in Word 'understands' the line break from Excel so retains it. Notepad (and other similar programs) don't understand the line break so either ignore it entirely or indicate to the user that there's a 'not-understood' character in the pasted string, by putting quotation marks around the string.

    Basically, what I'm saying is that what's happening is by design in Notepad and I don't think there's anything you can do to 'fix' it. Sorry.

    Regards,
    Aardigspook

    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
    You don't need to give me rep if I helped, but thanks are appreciated.

  15. #15
    Registered User
    Join Date
    05-24-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: CONCATENATE adds quotes - How to suppress?

    =CONCATENATE(SUBSTITUTE(R2, CHAR(10), "") & " . . . " & S2)

    CHAR(10) = LINE FEED . . . http://www.lookuptables.com/

    Doesn't work.
    This gets rid of the Line Feeds, which gets rid of all the extra quotes,
    but, I need the Line Feeds

  16. #16
    Registered User
    Join Date
    05-24-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: CONCATENATE adds quotes - How to suppress?

    =CONCATENATE(SUBSTITUTE(R2, CHAR(10), CHAR(32)) & " . . . " & S2)

    CHAR(32) = SPACE . . . http://www.lookuptables.com/

    Doesn't work.
    This replaces the Line Feeds with a Space, which gets rid of all the extra quotes from when I copy and paste,
    but, I need the Line Feeds . . . and now the text has a lot of extra Spaces

  17. #17
    Registered User
    Join Date
    05-24-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: CONCATENATE adds quotes - How to suppress?

    Still no explanation for this.

    What goes on from a copy and paste, to Notepad++ or MS Notepad, that has different results?

    It is something I cannot see. It is something that only the programmer of Excel would know.

    The Notepad++ community also remains silent. I always have the most difficult questions:

    How to copy multi-line text (hard Return) from Excel without extra quotes? . . . https://notepad-plus-plus.org/commun...t-extra-quotes

    How to copy multi-line text (hard Return) from Excel without extra quotes? . . . Plugin Development . . . https://notepad-plus-plus.org/commun...t-extra-quotes

    Users try to help, but they're just stabs in the dark.

    Come on, now, people - let's work the problem. Failure is not an option!

  18. #18
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: CONCATENATE adds quotes - How to suppress?

    Can you upload a fresh example of what you are trying to do? Give what you are starting with and what you expect to have as an end result.

    I have read this thread and am completely confused as to what you are trying to do.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  19. #19
    Registered User
    Join Date
    05-24-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: CONCATENATE adds quotes - How to suppress?

    Hello. Thank you for taking a look! Please see the attached spreadsheet. This is at the bottom:

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    I use this spreadsheet to categorize and sort my Bookmarks. Please see the above for a sample - my nuclear links - so you can see what I'm doing.

    These nine URLs at the bottom, rows 610-618, are current things on which I have questions - waiting for an answer, or have to do

    These seven URLs at the bottom, rows 619-625, have to be categorized at left, then I will use the Sort column (X) at right on them, to move them above

    I share links by using the C & P column (W) - copy and paste
    . . . see what happens when you copy and paste cell W613 into Notepad++, and MS Notepad . . . this C & P contains hard returns
    . . . see what happens when you copy and paste cell W612 into Notepad++, and MS Notepad . . . this C & P does not contain hard returns

    The hard returns (Alt+Enter) within a cell (column R) make the Concatenate formula put quotes around the whole thing.

    Relatively speaking, Notepad++ does a better job than MS Notepad. Reason: All you have to do in Notepad++ is to edit out the surrounding quotes. MS Notepad has the quotes, removes the hard returns, and runs everything together.

    If you copy and paste cell W613 into MS Word 2010, however, the output is as expected - there are no quotes, and it keeps the hard returns

    How does Word 2010 know to show the C & P this way? Is the fix to get a plugin written for Notepad++, that does whatever Word 2010 is doing? . . . is that possible? . . . or, is there a setting in Excel 2010 that can be used?

    I use Notepad++ all the time, because it's fast, and strips away hidden characters (I think it does). That's why I'd like it to be able to work better with my C & P in this case.
    Attached Files Attached Files

  20. #20
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: CONCATENATE adds quotes - How to suppress?

    Any returns within the cell cause a copy to notepad to have quotes around the copy. Word recognizes what you are calling a hard return a soft return or line break. I believe that Word is pasting using Source Formatting. If saved from Word and brought back into Notepad, there are no quotes.

  21. #21
    Registered User
    Join Date
    05-24-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: CONCATENATE adds quotes - How to suppress?

    . . . Word recognizes what you are calling a hard return a soft return or line break.

    I see . . . that's interesting, thanks! . . . any idea how I could get NPP++ to do the same?

    "A soft return or soft wrap is the break resulting from line wrap or word wrap (whether automatic or manual), whereas a hard return or hard wrap is an intentional break, creating a new paragraph."

    Another definition . . . http://www.webopedia.com/TERM/S/soft_return.html

    . . . you can insert a non-paragraph line break, also known as a soft return, by pressing shift-enter [this doesn't work] . . . http://www.mswordhelp.com/soft-return-in-word/

    - - - - - - - - - -

    keywords: notepad++, plugin, excel hard return to soft return

    or: notepad++, plugin, no quotes around hard return

    - - - - - - - - - -

    This page shows the symbols for a
    Hard Return (paragaph marks)
    and a
    Soft Return (manual line breaks)

    http://www.extendoffice.com/documents/word/661-replace-hard-returns-with-soft-returns.html

    So the question now is, how do you find one, and replace it with the other? Or, how do I do a soft return (Shift+Enter) within the Excel cell?

    - - - - - - - - - -

    http://www.proz.com/forum/office_applications/122695-how_to_search_and_replace_for_manual_line_break_in_excel.html

    Use Ctrl+F to find hard returns: Alt+0010

    Ok, I can find them. Is there an ASCII for Soft Returns? Not that I see.

    - - - - - - - - - -

    Maybe something in this program would work? . . . Save time with ASAP Utilities for Excel “The most popular add-in for Excel users” . . . http://www.asap-utilities.com/

    - - - - - - - - - -

    This looks like a good idea, but doesn't work. Extra characters show up. I'm thinking that I could do this just for the entries that have more than one line:

    "Type your title in Microsoft Word with the return. You can then copy and paste it into the Excel cell where you want the 2 separate lines."

    How to enter a carriage return in an Excel file . . . http://superuser.com/questions/46128/how-to-enter-a-carriage-return-in-an-excel-file

    - - - - - - - - - -

    Is it impossible to do a soft return within an Excel cell?

  22. #22
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: CONCATENATE adds quotes - How to suppress?

    Other than Alt+Enter the other method is to use CHAR(10) and turn on Wrap Text. This however has no effect on eliminating the " marks.

    I see nothing for Notepad++ that would eliminate the quotes.

  23. #23
    Registered User
    Join Date
    05-24-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: CONCATENATE adds quotes - How to suppress?

    Ok, thanks.

    It looks like the best way (no thinking or editing required) to handle this, then, is . . . for entries with hard returns:

    1.) copy and paste it to Word 2010

    2.) copy and paste that to Notepad++

    . . . so there's one extra step involved

    Do you think this is something that would be addressed in a future version of Excel? . . . the ability to do soft returns within a cell?

  24. #24
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: CONCATENATE adds quotes - How to suppress?

    Excel does soft returns -- that's what happens when you wrap text. It's not a character that appears in the cell.

  25. #25
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: CONCATENATE adds quotes - How to suppress?

    The only problem with the wrap text is that the wrap point is determined by the width of the cell.

    I doubt very much that this would be addressed in future editions of Excel as Excel is a "number cruncher" and not a text editor. Excel works well with other Office products so I really don't anticipate accommodations to be made for other products especially for niche applications.

    Word can save as a TXT file that is compatible with Notepad and that may be better than copying and pasting. Only experimenting will determine what works for you.

    Good luck.

  26. #26
    Registered User
    Join Date
    05-24-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: CONCATENATE adds quotes - How to suppress?

    I mean, where *I* specify to put the soft return.

    I should be able to do Shift+Enter, and it goes to the next row - and then when I do copy and paste, it doesn't put quotes around the concatenated items.

  27. #27
    Registered User
    Join Date
    05-24-2011
    Location
    Cleveland, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    41

    Re: CONCATENATE adds quotes - How to suppress?

    To me, it's along the same lines of how when you want to convert data from one format to another - like from some database format to xls, or csv - one will give you garbage characters, and another won't.

    But, it does have some text editing features. You can do things in ASCII with it.

    I wonder what Word 2010 sees, that Notepad++ doesn't. It seems like a plugin could be done so it would work, but I have no idea how.

    Thanks for your help!

  28. #28
    Registered User
    Join Date
    07-23-2012
    Location
    Fishers, IN
    MS-Off Ver
    Excel 2013
    Posts
    16

    Re: CONCATENATE adds quotes - How to suppress?

    I have been unsuccessful in all aspects of trying to remove the double quotes generated from breaking a line in a concatenate/concat formula. (I am trying to accomplish this on a sharepoint excel file, not sure if this complicates anything... but so far nothing has worked to remove the double quotes. I even tried using SUBSTITUTE with CHAR(34) at the end of my formula to try to remove the double quotes.
    ORIGINAL Formula = =CONCAT(L144," - ",M144," - ", F144," ", CHAR(10), Q144)
    2nd Attempt Formula = =SUBSTITUTE(CONCATENATE(L129," - ",M129," - ", F129, CHAR(10), Q129), CHAR(34), "")
    I still get quotes when Copy and Pasting outside of Excel... Everything I have read said there is no way around this, but I and all of you, I can assume anyways, won't accept that answer... and we will find a way around it ha
    Best Regards,

    JC

  29. #29
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,891

    Re: CONCATENATE adds quotes - How to suppress?

    jclegg. It is a forum rule that you should not piggy-back on other peoples threads... even ancient ones like this.

    Please start your OWN thread, preferable with a sample file that shows what you have and what you WANT.

    This thread is closed.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Concatenate adds 0
    By d.i.y. man in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-10-2013, 12:13 PM
  2. Adding commas to cell adds unwated quotes
    By Hood in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-05-2013, 01:00 PM
  3. Using "Append", adds unwanted double quotes. How to remove them?
    By thelisa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2013, 09:35 AM
  4. Replies: 19
    Last Post: 03-04-2013, 01:16 PM
  5. [SOLVED] Format for Concatenate formula which includes single quotes
    By jacob@thepenpoint in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-04-2012, 03:32 PM
  6. Replies: 0
    Last Post: 12-22-2011, 03:42 PM
  7. DDE Live Data for stock quotes (cell reference concatenate)
    By barnzee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2007, 06:33 AM
  8. [SOLVED] Concatenate columns, separated by double quotes
    By Felicia in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-20-2005, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1