Results 1 to 13 of 13

Thread: Replace double spaces

Threaded View

  1. Aug 25th, 2012, 12:05 PM #8
    Yumby
    Yumby is offline

    Thread Starter
    Lively Member Yumby's Avatar
    Join Date
    Feb 2009
    Posts
    120

    Re: Replace double spaces

    Here's my current file/row....

    "word1", "wo rd2", "word3 ", " word4"

    And I tried this.....
    Code:
    If datval.Contains("  ") = True Then
MsgBox("2 spaces in " & wordat(x))
    But it only identifies "wo rd2" (not "word3 " or " word4") so what am I doing wrong now?

    DataMiser - Thanks, I'll work on that after I sort out this problem.
    Last edited by Yumby; Aug 25th, 2012 at 12:12 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width