Results 1 to 4 of 4

VBA to remove space on for, between, end number

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-21-2015
    Location
    nederland
    MS-Off Ver
    2021
    Posts
    206

    VBA to remove space on for, between, end number

    Dear All,

    Please help how to remove space on for, between, end number
    I use below VBA

    Sub deletespace()
    
         
        Dim rRange As Range
        
        Set rRange = ActiveSheet.Range("A2:A4")
        rRange.Replace What:=Space(1), Replacement:="", _
              SearchOrder:=xlByColumns, MatchCase:=True
              
        Set rRange = rRange.Find(What:=Space(1))
        
        If Not rRange Is Nothing Then
            
           
        End If
        
    End Sub
    Attached Images Attached Images
    Last edited by kirana2014; 09-26-2021 at 01:07 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trying to remove a space before a number in a cell
    By Guilty32 in forum Excel General
    Replies: 2
    Last Post: 12-01-2018, 11:06 AM
  2. How to remove space between number and replace with period
    By navids in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-30-2017, 09:45 AM
  3. [SOLVED] remove space between number and english in one cell
    By hktom in forum Excel Formulas & Functions
    Replies: 56
    Last Post: 12-29-2015, 03:54 PM
  4. [SOLVED] To Remove Space in number
    By ganeshkumar in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-01-2013, 06:01 AM
  5. Remove Space between number and letter on excel spreadsheet
    By BowHunter09 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2013, 09:06 PM
  6. Remove trailing space from a cell, convert to number
    By lil_ern63 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2010, 12:19 PM
  7. Replies: 6
    Last Post: 06-29-2006, 01:20 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1