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

    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
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 17
    What do the asterisks represent?
    If the required element of the data is always the last three characters, use
    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