+ Reply to Thread
Results 1 to 8 of 8

" " " is coming when i am using concat formular

  1. #1
    Registered User
    Join Date
    08-25-2017
    Location
    Seoul
    MS-Off Ver
    2016
    Posts
    5

    " " " is coming when i am using concat formular

    Hi, it is first thread in here.

    now i am working to make online shop.
    i am using excel 2016 to do under thing
    -----under-----
    there are several types of state or description (ex: product name, the things included, color, weight, claimed weight by menufacturer, photo)
    ->
    start doing excel.
    ->
    just type those properties in cells
    ->
    those properties are come out with HTML code in specific cell by some programmed logic and by summing using concat
    ->
    just ctrl+c that cell
    ->
    just ctrl+v that data in my admin program or notepad
    ->x
    error occured
    -> every cell data which is concentrated already, has a -> " <- this. even putting in notepad!

    for example.
    a1 = code is blocked by excel forum
    a2 = 상품명
    if i concentrate it using formular concat
    it appears like it
    "code"" is blocked by excel forum"상품명

    that " is appeared not only in front of that code but also in the middle of code.!
    i passed all night today making this....
    please help me

    Because excelfrum do not allow HTML code in thread, i uploaded excel file.
    Attached Files Attached Files
    Last edited by LEE KI; 08-25-2017 at 01:01 PM.

  2. #2
    Registered User
    Join Date
    08-25-2017
    Location
    Seoul
    MS-Off Ver
    2016
    Posts
    5

    Re: " " " is coming when i am using concat formular

    in attached excel file, O34 cell is my target cell. that cell could be contain whole HTML code by concentrating. so it could be paste in admin program.

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: " " " is coming when i am using concat formular

    i tried and...
    ->
    상품명
    =IF(F4=0,CONCAT($M$11,B4)," ")

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: " " " is coming when i am using concat formular

    1. you need save your file as .xlsm (macro enabled) because CONCAT is UDF (VBA) function and it doesn't work in standard xlsx file
    2. you should check if your vba code for concat still exist in your file

    or

    your excel version is 2016 for subscribers (de facto: 365)


    CONCAT function
    Applies To: Excel 2016 Excel 2016 for Mac Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Mobile Excel for Android phones
    Note: This feature is only available if you have an Office 365 subscription
    Last edited by sandy666; 08-25-2017 at 01:58 PM.

  5. #5
    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,893

    Re: " " " is coming when i am using concat formular

    I'm sorry, but I do not understand what you are trying to do. Please delete EVERYTHING that is irrelevant and report showing your expected answer..
    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

  6. #6
    Registered User
    Join Date
    08-25-2017
    Location
    Seoul
    MS-Off Ver
    2016
    Posts
    5

    Re: " " " is coming when i am using concat formular

    I solved it.
    causation about that problem is "alt+enter"
    if i have a cell which contains empty row (using alt+enter)
    if i use "CONCATENATE" to summing several cells including that cell,
    if i paste result cell of "CONCATENATE" into notepad or somewhere else,
    result will appears with quotation mark in front side as well as in the back side.

    any way thank you all

  7. #7
    Registered User
    Join Date
    08-25-2017
    Location
    Seoul
    MS-Off Ver
    2016
    Posts
    5

    Re: " " " is coming when i am using concat formular


    i solved.
    problem was a using alt+enter

  8. #8
    Registered User
    Join Date
    08-25-2017
    Location
    Seoul
    MS-Off Ver
    2016
    Posts
    5

    Re: " " " is coming when i am using concat formular

    i solved.
    problem was a using alt+enter

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. Replies: 2
    Last Post: 07-24-2017, 02:19 AM
  3. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  4. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  5. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  6. [SOLVED] How can we formular a dynamic cell? i.e. =B2 as ="B"&"2"??
    By qatest in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] How can we formular a dynamic cell? i.e. =B2 as ="B"&"2"??
    By qatest in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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