+ Reply to Thread
Results 1 to 5 of 5

CONCATENATE Spacing Issue Due to String Lengths

  1. 10-17-2008, 10:41 AM #1
    ffmariners
    ffmariners is offline
    Registered User
    Join Date
    09-06-2008
    Location
    Philly
    Posts
    40

    CONCATENATE Spacing Issue Due to String Lengths

    Hey, if you look in Column G you will notice the number on the right side of the column is indented one space too many (for any number that is 6 long in column A).

    Is there any way to do an IF C=6 and then have it remove a space from before the number in Column G to have it line up?
    Attached Files Attached Files
    Last edited by ffmariners; 10-17-2008 at 01:52 PM.
    Reply With QuoteRegister To Reply
  2. 10-17-2008, 12:20 PM #2
    snasui
    snasui is offline
    Forum Contributor snasui's Avatar
    Join Date
    07-15-2007
    Location
    Songkhla, Thailand
    MS-Off Ver
    2010, 365
    Posts
    167
    Try this,

    G1

    Please Login or Register  to view this content.
    Copy down.

    In cell H1 type Len(G1) and copy down for check text length in column G.
    Reply With QuoteRegister To Reply
  3. 10-17-2008, 01:51 PM #3
    ffmariners
    ffmariners is offline
    Registered User
    Join Date
    09-06-2008
    Location
    Philly
    Posts
    40
    Thanks!

    I do not need the length check in H, right? It seems to work without that.

    What is the logic behind the (E1,42) ... what is it doing so I know for future reference?
    Reply With QuoteRegister To Reply
  4. 10-17-2008, 01:54 PM #4
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    What is the logic behind the (E1,42)
    This returns the first 42 characters of cell E1 from the left
    =LEFT(E1,42)
    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!
    Reply With QuoteRegister To Reply
  5. 10-17-2008, 02:32 PM #5
    ffmariners
    ffmariners is offline
    Registered User
    Join Date
    09-06-2008
    Location
    Philly
    Posts
    40
    Oh, great!

    Thanks for the heads up!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Concatenate Issue
    By Chris Skittz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-01-2010, 01:56 PM
  2. inputbox for simple verification purposes?
    By durandal05 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-08-2008, 06:03 PM
  3. check string value inside cell and concatenate?
    By MacExcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-23-2008, 07:31 PM
  4. Cell formula from concatenate string
    By sailingdan in forum Excel General
    Replies: 1
    Last Post: 11-06-2007, 05:28 PM
  5. Concatenate string variables in VB
    By Willow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2006, 09:59 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1