Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2003
    Posts
    191
    Thanks
    0
    Thanked 0 Times in 0 Posts

    data cleansing (xl2002)

    Hi Folks,
    I have a column of data in column E which contains data like 1PR UNI P45687. Where UNI exists in the string I would like to replace the entire string within the cell with 101. What is the best way of doing this please ?

    Thanks Bill

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: data cleansing (xl2002)

    In your previous question, UNI could be anything. I take it that this time, you mean the literal and fixed text UNI.
    - Select the column
    - Select Edit | Replace
    - In the 'Find what' box, type <code>* uni *</code>
    - In the 'Replace with' box, type <code>101</code>
    - Click Options >>
    - Tick the check box 'Match entire cell contents'
    - Click 'Replace All'

Posting Permissions

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