Results 1 to 10 of 10

To Delete specific letters from the cells

Threaded View

  1. #1
    Valued Forum Contributor abduljaleel.mca's Avatar
    Join Date
    02-13-2013
    Location
    Chennai, India
    MS-Off Ver
    MS 365 Business
    Posts
    326

    To Delete specific letters from the cells

    Hi,

    Below is my partial programming code

    
    na = Split(Cells(1, i - 1).Address, "$")(1)
    If Left(Cells(x + 1, k), 1) = na Then
        Selection.ClearContents
    End If
    Using some condition I am getting the address of a cell. My program show a output of 'C' according to the data I have. Now I need to delete the char 'c' in all cells. The problem is below

    my program works suppose if char 'c' appear as a single char in a cell.
    It does not work in the combination of characters.

    C -> It works
    NC -> It does not work

    Some programming modification needed in this line

    
    If Left(Cells(x + 1, k), 1) = na Then
    Please help.
    Last edited by abduljaleel.mca; 04-15-2013 at 10:41 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1