+ Reply to Thread
Results 1 to 7 of 7

To remove Space

  1. 02-17-2014, 09:15 AM #1
    Shradharani
    Shradharani is offline
    Registered User
    Join Date
    08-03-2012
    Location
    India.Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    97

    To remove Space

    Hi ,

    I have a list of names in column in excel in which each cell end with some space I want to delete that space in shot .

    Please help. I have attached excel for reference.

    Thanks and regards,
    Shradha
    Attached Files Attached Files
    Last edited by Shradharani; 02-17-2014 at 09:31 AM.
    Reply With QuoteRegister To Reply
  2. 02-17-2014, 09:18 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,371

    Re: To remove Space

    Type this into B2: =TRIM(A2)
    Reply With QuoteRegister To Reply
  3. 02-17-2014, 09:22 AM #3
    Shradharani
    Shradharani is offline
    Registered User
    Join Date
    08-03-2012
    Location
    India.Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    97

    Re: To remove Space

    This removes space between two words again ... I want only end space to be removed
    Reply With QuoteRegister To Reply
  4. 02-17-2014, 09:23 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,371

    Re: To remove Space

    We have cross-posted - please look at my amended post above.
    Reply With QuoteRegister To Reply
  5. 02-17-2014, 09:31 AM #5
    Shradharani
    Shradharani is offline
    Registered User
    Join Date
    08-03-2012
    Location
    India.Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    97

    Re: To remove Space

    Thanks its working now
    Reply With QuoteRegister To Reply
  6. 02-17-2014, 09:39 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,371

    Re: To remove Space

    My pleasure!
    Reply With QuoteRegister To Reply
  7. 02-17-2014, 09:41 AM #7
    hemesh
    hemesh is offline
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: To remove Space

    try this in b2 assuming your data starts from Cell A2

    =TRIM(LEFT(A2,FIND(CHAR(9),A2)-1))


    Trim Alone will not be able to remove extra spaces in your data!
    apply trim formula to certain cell and copy the same then paste as values! There will be spaces !
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to remove empty space, unable to make pvot, because pvot calculate empty space
    By vengatvj in forum Excel Charting & Pivots
    Replies: 20
    Last Post: 10-29-2013, 12:43 PM
  2. [SOLVED] If Cell Starts with a Space, remove that space
    By Ocean Zhang in forum Excel General
    Replies: 2
    Last Post: 09-29-2012, 01:52 PM
  3. trying to remove a space
    By eddybrown in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-18-2012, 07:25 PM
  4. Remove after first space
    By orlycnd in forum Excel General
    Replies: 1
    Last Post: 01-11-2011, 10:36 AM
  5. how to remove space
    By avk in forum Excel General
    Replies: 3
    Last Post: 01-09-2010, 03:48 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1