Results 1 to 3 of 3

How to split this long string code in multiple line to avoid an error???

Threaded View

tuongtu3 How to split this long string... 11-24-2013, 03:36 AM
Bob Phillips Re: How to split this long... 11-24-2013, 07:48 AM
tuongtu3 Re: How to split this long... 11-24-2013, 10:08 PM
  1. #1
    Forum Contributor
    Join Date
    08-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2007, MS 365 (Windows 10 Pro 64-bit)
    Posts
    818

    How to split this long string code in multiple line to avoid an error???

    Hello All:
    Please help me to split the below long string in multiple lines
    IF(ISNA(MATCH($C2&""-""&$D2&""-""&$F2,INDEX(Sheet2!$X$1:$X$15000&""-""&Sheet2!$AH$1:$AH$15000&""-""&Sheet2!$F$1:$F$15000,0),0)),"""",(""Will be ""&IFERROR(TEXT(INDEX(Sheet2!$J$1:$J$15000,MATCH($C2&""-""&$D2&""-""&$F2,INDEX(Sheet2!$X$1:$X$15000&""-""&Sheet2!$AH$1:$AH$15000&""-""&Sheet2!$F$1:$F$15000,0),0)),""mm/dd/yyyy""),"""")&"", has been ""&IFERROR(INDEX(Sheet2!$D$1:$D$15000,MATCH($C2&""-""&$D2&""-""&$F2,INDEX(Sheet2!$X$1:$X$15000&""-""&Sheet2!$AH$1:$AH$15000&""-""&Sheet2!$F$1:$F$15000,0),0)),"""")&"", status is ""&IFERROR(INDEX(Sheet2!$M$1:$M$15000,MATCH($C2&""-""&$D2&""-""&$F2,INDEX(Sheet2!$X$1:$X$15000&""-""&Sheet2!$AH$1:$AH$15000&""-""&Sheet2!$F$1:$F$15000,0),0)),"""")&"", has been ""&IFERROR(INDEX(Sheet2!$AC$1:$AC$15000,MATCH($C2&""-""&$D2&""-""&$F2,INDEX(Sheet2!$X$1:$X$15000&""-""&Sheet2!$AH$1:$AH$15000&""-""&Sheet2!$F$1:$F$15000,0),0)),"""")))
    Regards,
    tt3
    Last edited by tuongtu3; 11-25-2013 at 01:36 AM. Reason: Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Converting Unformatted string into Time Value (VBA; error on one line of code)
    By aloha31 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2013, 04:41 PM
  2. [SOLVED] long line in the macro code giving sytax error
    By hnpsingh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-28-2012, 12:46 PM
  3. Can excels Split() function split a string up at multiple spots?
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2011, 02:36 PM
  4. Split string by line break into array
    By kennychung in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2009, 12:18 PM
  5. [SOLVED] Need to split one long column into multiple rows
    By agbiggs@hotmail.com in forum Excel General
    Replies: 2
    Last Post: 03-07-2006, 04:46 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