Separate a column into 2
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Separate a column into 2

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have an item number and description in a column all together. The item numbers are all 5 digits followed by the description. Is there a way to remove the first 5 characters and put them into a new column?

    Thanks in advance for any help.

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Data, Text to Columns

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Los Angeles, CA
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi teebruin,
    Just to elaborate on what lenze have said,
    highlight the desired column,go to Data, text to columns, fixed width, next, create your breakline on desired position then finish...
    Happy Easter...!
    Ed Namzug

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thank You. I knew it would be something simple.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com