Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Remove Text (2000)

    Hi, I want to remove the following from each cell in a column of data: a space then the word count.

    Any suggestions?

    Thanks.

  2. #2
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Remove Text (2000)

    Used Edit, Find, Replace... to get rid of.

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Remove Text (2000)

    Are you trying to remove:
    " count "
    or something like:
    " 15 "
    where the '15' is a word count?

    For the former, try:
    =RIGHT(A1,LEN(A1)-7)
    For the latter, try:
    =RIGHT(A1,LEN(A1)-LEN(SUMPRODUCT(VALUE(LEFT(TRIM(A1),FIND(" ",TRIM(A1))-1))))-2)

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •