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

**pauldaddyadams** · 02-03-2016, 09:50 AM

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?

**alansidman** · 02-03-2016, 10:02 AM

try this: =LEFT(B3,FIND("D",B3)-1) and copy down

**AlKey** · 02-03-2016, 10:10 AM

Or enter in C3 and copy down

Formula:

Please Login or Register  to view this content.

**pauldaddyadams** · 02-03-2016, 10:46 AM

Thanks - both solutions work brilliantly.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

How to make a Pivot Table "Top 10" include an "other" category.

regex: include split "0=" like "a=" into .pattern

create text string: "NOT "[b2value]", NOT "[b3value]", ..., NOT "[b600value]"

A function to change "text" to "numbers" so the result can be calculated.

Help Needed to get Filters Using "Include" and "Exclude" multiple values on one column.

How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro

Replace numbers with Text ("1" to "Apple", for example)

Bookmarks

Bookmarks

Posting Permissions