+ Reply to Thread
Results 1 to 6 of 6

Text to columns limit output

  1. #1
    Forum Contributor
    Join Date
    06-22-2011
    Location
    somerset
    MS-Off Ver
    365
    Posts
    330

    Text to columns limit output

    I have a table 2 columns wide insert a column B and use text to columns to split column A into A and the new B but it keeps overwriting C with blanks.
    start sample:
    Level & Part Numbers Description
    5 NAS1130-3L20D INSERT HCOIL 10/32 UNF .380L
    5 NAS1130-3L20D INSERT HCOIL 10/32 UNF .380L
    5 NAS1130-3L20D INSERT HCOIL 10/32 UNF .380L
    Prepared to:
    Level Part Numbers Description
    5 NAS1130-3L20D INSERT HCOIL 10/32 UNF .380L
    5 NAS1130-3L20D INSERT HCOIL 10/32 UNF .380L
    5 NAS1130-3L20D INSERT HCOIL 10/32 UNF .380L
    Text to col desire
    Level Part Numbers Description
    5 NAS1130-3L20D INSERT HCOIL 10/32 UNF .380L
    5 NAS1130-3L20D INSERT HCOIL 10/32 UNF .380L
    5 NAS1130-3L20D INSERT HCOIL 10/32 UNF .380L
    Actual result:
    Level Part Numbers Description
    5 NAS1130-3L20D
    5 NAS1130-3L20D
    5 NAS1130-3L20D

    Full code:
    Please Login or Register  to view this content.
    Area of concern:
    Please Login or Register  to view this content.
    Sub Reputation()
    Dim Problem as Variant
    Dim Reputation as Integer
    For Each Problem in Forum.Threads
        If Problem.Title = "*[Solved]*" and Solver.Name = "Leon V (AW)" Then Reputation = Reputation + 1
    Next Problem
    End Sub

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,835

    Re: Text to columns limit output

    Data in col.A should have extra space at the end, so why not inserting 2 columns and delete one after the process...
    Please Login or Register  to view this content.
    ?

  3. #3
    Forum Contributor
    Join Date
    06-22-2011
    Location
    somerset
    MS-Off Ver
    365
    Posts
    330

    Re: Text to columns limit output

    Quote Originally Posted by jindon View Post
    Data in col.A should have extra space at the end, so why not inserting 2 columns and delete one after the process...
    Nope, didn't work, Same result... Also Col A is being trimmed so shouldn't have spaces at the end.
    Last edited by Leon V (AW); 01-08-2020 at 12:38 PM.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,640

    Re: Text to columns limit output

    Administrative Note:

    Please don't quote entire posts unnecessarily. They clutter threads and make them hard to read.
    Use the "Quick reply" instead
    Thanks

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,835

    Re: Text to columns limit output

    Then need to see your workbook.

  6. #6
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Text to columns limit output

    Change this argument

    FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 9), Array(4,9))
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ 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. [SOLVED] Copy across 9 columns of source data into 9 columns of an output table
    By nunez100 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-29-2019, 10:19 AM
  2. [SOLVED] Cell reference, output dates to numeric. Should output as text
    By lifeseeker1019 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-02-2015, 05:51 PM
  3. [SOLVED] Match text in 2 columns, if true output adjacent cell to the match.
    By kenoboy in forum Excel General
    Replies: 3
    Last Post: 07-03-2012, 09:52 AM
  4. Compare 2 columns near equiv (one has text included) and output to new column
    By CNE5x in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2012, 01:24 PM
  5. Replies: 6
    Last Post: 01-09-2012, 03:34 PM
  6. Looping through columns to copy output into other sheet, and saving output
    By eludlow in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2009, 06:27 AM
  7. Replies: 4
    Last Post: 10-09-2005, 04:05 PM

Tags for this Thread

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