+ Reply to Thread
Results 1 to 3 of 3

Good Morning- Can I delete the last text line in all 5000 cells

  1. #1
    Registered User
    Join Date
    01-29-2005
    Posts
    15

    Talking Good Morning- Can I delete the last text line in all 5000 cells

    Hello,
    Thank you for reading my forum post.
    I have a excel doc with 5000 item descriptions. Each of the 5000 cell's has a text paragraph in it. All of these cells are in 1 column with 5000 rows. I need to delete the last text line of every cell in this whole doc.

    Thank you for your help.

    Have a nice day.

    Rob

  2. #2
    Forum Contributor
    Join Date
    04-11-2005
    Location
    London
    Posts
    259
    Try something like:
    Please Login or Register  to view this content.
    This assumes that by the last line, you mean the last sentence signified by a full stop.

    I hope this helps
    MS

  3. #3
    Forum Contributor
    Join Date
    04-11-2005
    Location
    London
    Posts
    259
    Hi Rob.

    Some good news for you. You don't have to do any coding at all.

    As I understand your problem, you are after losing the last 86 characters in each cell in column A (up to 5000) whilst keeping the remaining 105 characters. Excel already has a function which will do this.

    1. Insert an extra column after column A which will now be blank & be called column B.

    2. In B1 type =LEFT(A1,105)

    3. Now autofill this until you reach the 5000th row.

    4. Select the whole of column B and click on Copy.
    5. Now right click anywhere in column B and click Paste Special and select "Values" and then click OK.

    You have just removed all of your dodgy data.

    Come back if you get any further problems.

    MS
    Martin Short

+ 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