+ Reply to Thread
Results 1 to 8 of 8

If concatenate

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2013
    Posts
    571

    Re: If concatenate

    like this:
    =$A$1&": "& IF(A2="","", TEXT(A2,"dd.mm.yyyy"))&" "&$B$1&": "& IF(B2="","",TEXT(B2,"dd.mm.yyyy"))&" "&$C$1&": "&C2&" "&$D$1&": "&D2&" "&$E$1&": "&E2&" "&$F$1&": "&F2
    Click (*) if you received helpful response.

    Regards,
    David

  2. #2
    Forum Contributor
    Join Date
    07-06-2012
    Location
    Bitola,Macedonia
    MS-Off Ver
    Excel 2007
    Posts
    132

    Re: If concatenate

    And when I delete A2 it is staying A1.

+ 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: 08-28-2014, 06:01 PM
  2. [SOLVED] VBA concatenate script does not excute as expected, Concatenate and "&" can't be dragged
    By VBAlex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2014, 09:25 AM
  3. Replies: 2
    Last Post: 04-12-2010, 12:35 PM
  4. IF, IF, Concatenate?
    By savvysam in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  5. [SOLVED] I know how to concatenate ,can one de-concatenate to split date?
    By QUICK BOOKS PROBLEM- in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 07-26-2005, 01: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