CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 6 of 6

Threaded View

  1. February 27th, 2006, 01:05 AM #5
    Sahir's Avatar
    Sahir
    Sahir is offline Senior Member
    Join Date
    Aug 2002
    Location
    Kerala
    Posts
    1,183

    Re: Splitting strings with decimal point

    Quote Originally Posted by italguy
    For example in my Excel sheet C36 may contain 16.11
    I wanna be able to split the string so I have 16 in one box and 11 in the other.
    Code:
      Dim s As String
  Dim arry() As String
  s = "16.11"
  arry = Split(s, ".", 2, vbBinaryCompare)
  MsgBox (arry(0))
  MsgBox (arry(1))
    Last edited by Sahir; February 27th, 2006 at 01:44 AM.
    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

Featured