+ Reply to Thread
Results 1 to 14 of 14

Taking an integer out of a string

Hybrid View

  1. #1
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Taking an integer out of a string

    What does the string look like you are using this on?

    Deck -- 32 -- 90

    or

    "Deck -- 32 -- 90"

    If it's the latter, can you do a find and replace, remove the "" and then try again.
    HTH
    Regards, Jeff

  2. #2
    Registered User
    Join Date
    06-01-2012
    Location
    Nova Scotia, Canada
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Taking an integer out of a string

    Quote Originally Posted by jeffreybrown View Post
    What does the string look like you are using this on?

    Deck -- 32 -- 90

    or

    "Deck -- 32 -- 90"
    Technically it looks like:

    Deck -- 32 -- 90(space)

    I would just use Right or some other function like that, but there are longer names and sometimes decimal places (doubles) so using right wouldn't be very effective and could cause some more problems.

+ 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