Results 1 to 8 of 8

Extracting values from mixed content in the cell.

Threaded View

  1. #1
    Registered User
    Join Date
    01-27-2011
    Location
    Novi Sad, Serbia
    MS-Off Ver
    Excel 2010
    Posts
    62

    Question Extracting values from mixed content in the cell.

    Hi guys,

    I have a one interesting problem and I need comunity help to solve it.

    Please take a look at this image:
    http://prntscr.com/hqg42y

    5.780 RSD is the date that I got by scraping certain HTML page and represents the price of certain product.
    Unfortunally in order to work with it I need value to be formated as number automatically.

    Is there certain formula that I can apply to get the value formated as number adter this scarping is done?

    Thank you
    Dean
    Last edited by Dolke; 12-21-2017 at 10:07 AM. Reason: Mod warning...

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Simple (?) chart prob--Needing a simple solution!
    By baloo308 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-06-2016, 12:24 PM
  2. solution hidden shett 2 and sheet 3
    By bogd1n in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2015, 03:54 PM
  3. Need a Macro or some solution to this simple problem
    By tcmazz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2014, 12:45 AM
  4. Replies: 1
    Last Post: 11-12-2012, 01:52 PM
  5. simple problem with drop down list. need solution
    By singhabhijitkumar in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-17-2011, 06:20 AM
  6. Replies: 5
    Last Post: 01-20-2006, 05:55 PM
  7. Simple solution?
    By Josiah in forum Excel General
    Replies: 1
    Last Post: 05-04-2005, 04:39 AM

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