Results 1 to 4 of 4

Strip out numbers only from text (include ".")

Threaded View

  1. 02-03-2016, 09:50 AM #1
    pauldaddyadams
    pauldaddyadams is offline
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Strip out numbers only from text (include ".")

    Hi,

    I have a number of cells which contain a numbering convention followed by a question. I would like to strip out only the number element if possible. The added twist is that I need it to include the “.” E.g.

    1.2.3 abcdefghijkl would become 1.2.3

    I have uploaded an example.

    Can anyone help please?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to make a Pivot Table "Top 10" include an "other" category.
    By Melvinrobb in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 09-09-2014, 05:15 AM
  2. regex: include split "0=" like "a=" into .pattern
    By DavidRoger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-02-2014, 01:32 AM
  3. create text string: "NOT "[b2value]", NOT "[b3value]", ..., NOT "[b600value]"
    By savekels in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  4. A function to change "text" to "numbers" so the result can be calculated.
    By skip2 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-05-2012, 10:23 AM
  5. Help Needed to get Filters Using "Include" and "Exclude" multiple values on one column.
    By alfykunable in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2012, 04:03 AM
  6. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 AM
  7. Replace numbers with Text ("1" to "Apple", for example)
    By pilotwings64 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-07-2008, 06:56 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1