Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2005
    Posts
    55

    Question Unanswered: text-to-column fixed width

    I have data as per below

    *** ABC
    ** DEF
    * GHI


    HOw can i use text to columns to split this so i have ABC in one column DEF in another column and GHI in another column

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    994
    Provided Answers: 2
    What do the asterisks represent?
    If the required element of the data is always the last three characters, use
    Code:
    RIGHT(Cell, 3)
    in the destination column.

Posting Permissions

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