how to get a position of a last number within a string e.g. "bla bla 522 to 604 bla"

**rain4u** · 12-08-2015, 08:42 PM

Haven't needed help for a while, but I'm bit stuck to find some simple solution.

I just need to get a position of a last number within a string e.g. "bla bla 522 to 604 bla"
So with this particular example the position of that number "4"

Please Login or Register  to view this content.

Any help is very much appreciated.
Cheers

**StuCram** · 12-08-2015, 09:13 PM

Try this:

Please Login or Register  to view this content.

**AlKey** · 12-08-2015, 09:20 PM

You can do this with formula

Formula:

Please Login or Register  to view this content.

the last number is 4 the position of that number is 18

Data Range

	A	B
1	bla bla 522 to 604 bla	18

**protonLeah** · 12-08-2015, 09:21 PM

Please Login or Register  to view this content.

**rain4u** · 12-08-2015, 09:32 PM

Originally Posted by protonLeah

Please Login or Register  to view this content.

This gets me the number itself "e.g. 604" which was my next step anyway so its PERFECT! Thank you.

Thank you everybody.
Cheers

how to get a position of a last number within a string e.g. "bla bla 522 to 604 bla"

LinkBack

Thread Tools

Rate This Thread

Display

how to get a position of a last number within a string e.g. "bla bla 522 to 604 bla"

Re: how to get a position of a last number within a string e.g. "bla bla 522 to 604 bla"

Re: how to get a position of a last number within a string e.g. "bla bla 522 to 604 bla"

Re: how to get a position of a last number within a string e.g. "bla bla 522 to 604 bla"

Re: how to get a position of a last number within a string e.g. "bla bla 522 to 604 bla"

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Count number of rows in a range that contain less than 5 cells with the string "VAC"

[SOLVED] Need formula that finds the last ", " in a text string & substitutes it w/ the word "and"

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

[SOLVED] Combo list selected by "contains" text string entered rather than "begins with"

Count the number of text string Occurence if the Value in another Column is "Adair"

[SOLVED] search for a "part number" within a string and return its cell position or contents of cel

[SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row

Bookmarks

Bookmarks

Posting Permissions