+ Reply to Thread
Results 1 to 4 of 4

Remove Space from first character of text

  1. #1
    Registered User
    Join Date
    06-01-2012
    Location
    kent
    MS-Off Ver
    excel 2010
    Posts
    9

    Remove Space from first character of text

    Hi I have about 1000 rows of data, and some have a space as the first character in the cell, as shown below

    3/4" BSP 3 MICRON 60LPM
    3/4" BSP 10 MICRON 95LPM
    3/4"BSP 25 MICRON 125LPM

    Is there a formula or macro I can use to remove them all in one go ?

  2. #2
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    66

    Re: Remove Space from first character of text

    =TRIM(A2) would do it if you don't mind having an additional column
    Last edited by TheNewUnion; 12-19-2012 at 07:09 AM. Reason: Bad typing

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,698

    Re: Remove Space from first character of text

    Not sure may be this...

    In A1 cell
    3/4" BSP 3 MICRON 60LPM

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Drag it down...


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Remove Space from first character of text

    select column
    then text to columns fixed width
    click next
    double click on any break lines to remove them
    click finish
    (you do say space as first character its not clear from your example what space you mean)
    if however you want to change
    3/4" BSP 3 MICRON 60LPM
    to
    3/4"BSP 3 MICRON 60LPM
    find "x where x = a single space
    replace with "
    Last edited by martindwilson; 12-19-2012 at 07:24 AM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

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