Results 1 to 6 of 6

Thread: Help Need about Excel Text Change Case Problems?

  1. #1
    kashifundlas is offline Senior Member
    Last Online
    2nd May 2019 @ 06:28 PM
    Join Date
    17 Feb 2009
    Age
    36
    Posts
    1,516
    Threads
    213
    Credits
    570
    Thanked
    55

    Wink Help Need about Excel Text Change Case Problems?

    freinds jaisay word mein shift+f3 press ker ky hum chotay alfaz ko baray urr baron ko chota ker saktay hain........mujhay excel mein iss ki zarort per gai aj achanak but mujhay koi options nahi mili text change case ki.....please experts bata dain hum easily sirf aik ya 2 cells ko ya kisi bhi specific row or column mein majood text ko kaisay change ker saktay hain in excel 2003.

  2. #2
    imranjhang's Avatar
    imranjhang is offline Senior Member+
    Last Online
    11th May 2021 @ 02:36 PM
    Join Date
    17 Dec 2009
    Age
    38
    Posts
    94
    Threads
    1
    Credits
    1,390
    Thanked
    13

    Default

    Excel main yeh kaam functions ki madad se kar saktay hein...

    case change karnay k yeh built in functions hein.

    1. =UPPER(A1)
    2. =LOWER(A1)
    3. =PROPER(A1)


    is main ap A1 ki jaga koi bhi cell reference day saktay hein

  3. #3
    kashifundlas is offline Senior Member
    Last Online
    2nd May 2019 @ 06:28 PM
    Join Date
    17 Feb 2009
    Age
    36
    Posts
    1,516
    Threads
    213
    Credits
    570
    Thanked
    55

    Default

    Quote imranjhang said: View Post
    Excel main yeh kaam functions ki madad se kar saktay hein...

    case change karnay k yeh built in functions hein.

    1. =UPPER(A1)
    2. =LOWER(A1)
    3. =PROPER(A1)


    is main ap A1 ki jaga koi bhi cell reference day saktay hein
    yar ye new column/row mein hota hai mein ossi column/row mein rehta huay kerna chahta hon

  4. #4
    syar is offline Advance Member
    Last Online
    Yesterday @ 06:12 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote kashifundlas said: View Post
    yar ye new column/row mein hota hai mein ossi column/row mein rehta huay kerna chahta hon
    Try
    1. Alt+F11
    2. Insert---->Module
    copy this code and paste in module

    Code:
    Sub testChangeCase()
        
        Static lngClickCount As Long
        Static strLastAddress As String         'this variable is for resetting the cycle
      
        Dim lngCase As VbStrConv
        Dim rngToCheck As Range
        Dim rngCell As Range
    
        
        On Error GoTo ErrorHandler
            
            
        If TypeOf Selection Is Range Then
            
            If strLastAddress = Selection.Address(External:=True) Then
                lngClickCount = lngClickCount + 1
            Else
                lngClickCount = 0
            End If
            
            strLastAddress = Selection.Address(External:=True)
            
            
            Select Case lngClickCount Mod 3
                Case 0
                    lngCase = vbLowerCase
                Case 1
                    lngCase = vbUpperCase
                Case 2
                    lngCase = vbProperCase
            End Select
                    
            If Selection.Cells.Count = 1 Then
                If Not Selection.HasFormula Then
                    If VarType(Selection.Value2) = vbString Then
                        Set rngToCheck = Selection
                    End If
                End If
            
            ElseIf Selection.Cells(1).MergeArea.Address = Selection.Address Then
                If Not Selection.HasFormula Then
                    If VarType(Selection.Value2) = vbArray + vbVariant Then
                        Set rngToCheck = Selection
                    End If
                End If
            
            Else
                On Error Resume Next
                Set rngToCheck = Selection.SpecialCells(xlCellTypeConstants, xlTextValues)
                On Error GoTo 0
            End If
            
    
            If Not rngToCheck Is Nothing Then
                Application.EnableEvents = False
                For Each rngCell In rngToCheck.Cells
                    rngCell.Value2 = StrConv(rngCell.Value2, lngCase)
                Next rngCell
            End If
            
        End If
    
    
    CleanUp:
        On Error Resume Next
        
        Application.EnableEvents = True
        
        Exit Sub
        
    ErrorHandler:
        MsgBox Err.Number & vbNewLine & Err.Description    'Debug.Print
        Resume CleanUp
        
    End Sub
    apne range ko select karain aur macro ko run karain. aap ka masla hal ho jae ga. Ya phir ASAP utilities download kar lain.

    regards,

  5. #5
    kashifundlas is offline Senior Member
    Last Online
    2nd May 2019 @ 06:28 PM
    Join Date
    17 Feb 2009
    Age
    36
    Posts
    1,516
    Threads
    213
    Credits
    570
    Thanked
    55

    Default

    yar thorsa detail mein bta detay na setup to setup to jiss ko nahi bhi pata meray jaisay ko osssy bhi pata chal jata k majra kia hai.........

  6. #6
    syar is offline Advance Member
    Last Online
    Yesterday @ 06:12 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote kashifundlas said: View Post
    yar thorsa detail mein bta detay na setup to setup to jiss ko nahi bhi pata meray jaisay ko osssy bhi pata chal jata k majra kia hai.........
    Macro ko run karne k aur lekhne ka pora procedure Excel Hep Line m Faisal Sb na lekha ha. Aap wahan p study kr lain aap ko pora samjh aa jae ga.

    regards

Similar Threads

  1. Solved apne user name k niche wala text kese change karun
    By Muhammaduf in forum Solved Problems (IT)
    Replies: 3
    Last Post: 3rd August 2012, 08:56 PM
  2. Solved How to Change the Excel Sheet from Right to Left and Vise Versa ???
    By Baazigar in forum Solved Problems (IT)
    Replies: 7
    Last Post: 7th December 2010, 10:15 PM
  3. Change excel cell color
    By umerao in forum Ask an Expert
    Replies: 3
    Last Post: 27th June 2010, 09:22 AM
  4. I need formula in excel
    By adnanbahrian in forum Ask an Expert
    Replies: 13
    Last Post: 22nd April 2010, 06:24 PM
  5. MS Office 2000 Shortcut Keys
    By general in forum General Discussion
    Replies: 4
    Last Post: 31st May 2007, 04:07 PM

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
  •