Results 1 to 16 of 16

how to take only numbers from text?

Threaded View

  1. #1
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Office365
    Posts
    388

    how to take only numbers from text?

    hello my helpful buddies,

    i want take only numbers from the sentence there.

    e.g.

    kazanan numaralar , 5 , 7 , 14 , 22 , 46 , 48 olarak belirlendi. ( from this sentence, i wanna take out only numbers as " 5 , 7 , 14 , 22 , 46 , 48 "

    how i can do this?
    pls look to example file. http://www.dosya.tc/server24/VT0ABq/...bers.xlsx.html
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Issue Having Formula Recognizing Numbers Saved As Text As Numbers
    By livifivil in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-08-2013, 01:34 PM
  2. [SOLVED] [SOLVED] Macro/Wildcard to remove only numbers excluding text with numbers
    By indianhp in forum Word Programming / VBA / Macros
    Replies: 6
    Last Post: 06-21-2013, 08:16 AM
  3. [SOLVED] Convert all numbers stored as text or custom formatted to numbers &no decimals - 40 sheets
    By synses in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2013, 01:46 AM
  4. [SOLVED] Vlookup formula - return only numbers for cells containing text and numbers
    By Andrew E Smith in forum Excel General
    Replies: 11
    Last Post: 07-03-2012, 06:07 AM
  5. Replies: 9
    Last Post: 03-26-2012, 02:16 PM

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