+ Reply to Thread
Results 1 to 6 of 6

How to remove only the first few characters in a row for whole column ???

  1. #1
    Registered User
    Join Date
    08-21-2011
    Location
    Zagreb
    MS-Off Ver
    Excel 2003
    Posts
    3

    Question How to remove only the first few characters in a row for whole column ???

    Hello....

    Can someone please help me ???

    I have 6000 rows in one column....and I want to remove only numerating....
    here is the sample how it looks like....

    12. Going to work - Monday (06:45)
    135. Buy beer - wine... (12:30)

    and so on......

    ands I want it to look like:

    Going to work - monday (06:45)
    Buy beer - wine... (12:30)

    Is there some easy way to do it in Excel ????
    Last edited by ljencina69; 08-21-2011 at 08:33 AM.

  2. #2
    Valued Forum Contributor scottylad2's Avatar
    Join Date
    09-03-2010
    Location
    edinburgh
    MS-Off Ver
    Office 2007 Prof & Office 2010 Student Edition
    Posts
    629

    Re: How to remove only the first few characters in a row for whole column ???

    Quote Originally Posted by ljencina69 View Post
    Hello....

    Can someone please help me ???

    I have 6000 rows in one column....and I want to remove only numerating....
    here is the sample how it looks like....

    12. Going to work - Monday (06:45)
    135. Buy beer - wine... (12:30)

    and so on......

    ands I want it to look like:

    Going to work - monday (06:45)
    Buy beer - wine... (12:30)

    Is there some easy way to do it in Excel ????
    will there always be a pace after the first full stop?12. Going to work - Monday (06:45)
    135. Buy beer - wine... (12:30)
    Windows 7 using Office 2007 & 2010

    Remember your [ code ] [ /code ] tags, makes reading soooo much easier

  3. #3
    Valued Forum Contributor scottylad2's Avatar
    Join Date
    09-03-2010
    Location
    edinburgh
    MS-Off Ver
    Office 2007 Prof & Office 2010 Student Edition
    Posts
    629

    Re: How to remove only the first few characters in a row for whole column ???

    Try this in B1

    =RIGHT(A1,LEN(A1)-FIND(" ",A1)) your text in A1 and drag down

  4. #4
    Registered User
    Join Date
    08-21-2011
    Location
    Zagreb
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: How to remove only the first few characters in a row for whole column ???

    yes, every row is exactly like in the samples, only the different number, text and time at the end...

  5. #5
    Registered User
    Join Date
    08-21-2011
    Location
    Zagreb
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: How to remove only the first few characters in a row for whole column ???

    Quote Originally Posted by scottylad2 View Post
    Try this in B1

    =RIGHT(A1,LEN(A1)-FIND(" ",A1)) your text in A1 and drag down
    not working...

  6. #6
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: How to remove only the first few characters in a row for whole column ???

    Hi
    I have moved your thread to a more suitable forum.
    Please read forum rules

    Scottylad,

    please refarin from quoting entire posts unnecessarily. They clog the forum and make the thread hard to read
    Thx

+ 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