Results 1 to 5 of 5

Text extraction using numbers MID()

Threaded View

  1. #1
    Registered User
    Join Date
    08-08-2005
    Posts
    76

    Text extraction using numbers MID()

    I am trying to extract a text based on a cell containing a number set to 3 decimal places, ie. A1 = 7.140

    I have been using the following formula - MID(A1,1,1)&MID(C13,3,3)&"0" which yields 7140.

    The goal is to extract all four numbers sequentially excluding the decimal (it is used as an automated text feed for another long formula), ie. want:

    7.142 => 7142
    7.140 => 7140
    7.700 => 7700

    The problem is the formula above falls apart for the first and third example where 7.142 outputs 71420 and 7.700 outputs 770.

    Is there any other function that can read the character 0?
    Last edited by heatwave; 04-04-2011 at 03:08 AM.

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