Consulting

Results 1 to 2 of 2

Thread: Solved: Remove part of the data in a cell

  1. 03-31-2006, 04:22 PM #1
    Tenspeed39355
    Tenspeed39355 is offline
    VBAX Tutor
    Joined
    Sep 2004
    Posts
    293
    Location

    Solved: Remove part of the data in a cell

    Hi there guys. I have downloaded some data and put it in excel ss
    The data in column H has the name of the fund and on the next line it has the date. Is there a way to remove the name of the fund and retain the date? If there was only one to remove it would not be a problem. There are 800 rows that need to be changed. I tried to do a text to coumns but that did not work. Thanks for your time with this matter
    Max
    Reply With Quote Reply With Quote
  2. 04-01-2006, 05:24 AM #2
    johnske
    johnske is offline
    Administrator
    Chat VP     VBAX Guru johnske's Avatar
    Joined
    Jul 2004
    Location
    Townsville, Australia
    Posts
    2,872
    Location
    [vba]
    Option Explicit
    Sub DeleteText()
    Columns("H").SpecialCells(xlCellTypeConstants, xlTextValues).ClearContents
    End Sub
    [/vba]

    EDIT: (No response for 12 days so will assume the problem is Resolved)
    You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you

    The major part of getting the right answer lies in asking the right question...


    Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules