#1
|
|||
|
|||
How to extract only numbers from a STRING?
Hi,
How can I extract the numbers from a string from a cell. Example: I have the below data in Cell A1 and would like to extract only numbers in to Cell B1: Data in Cell A1: Purchasing Document 7500840745 Result in CELL B1 shall be : 7500840745 Thanks. |
#2
|
||||
|
||||
Hi,
If you can assume that the number will always come at the end, this formula will do it: Code:
=TRIM(MID(A1,MIN(SEARCH({1,2,3,4,5,6,7,8,9,0},A1&"1235467890")),255))+0 |
#3
|
|||
|
|||
Quote:
Regards. |
#4
|
|||
|
|||
Extract number from alphanumberic
hello, can you please help me with extracting numbers from alphanumeric
for example I have: PANDA # 1 THALATHEEN STREET PANDA # 2 MALAZ GULF BRIDGE# 03, JEDDAH, SARI STPANDA # 4 HARAPANDA # 5 BATHA I just need numbers from it. Thanks |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can't See Attachments When E-mail String is Saved to PDF | wineattorney | Outlook | 1 | 03-29-2011 02:15 AM |
Extract numbers from a text string | aleale97 | Excel | 4 | 02-10-2011 10:33 AM |
inserting a string of data into an MS Word table??? | matto | Word VBA | 0 | 07-16-2010 09:35 AM |
Macro or Function to know wether a string is included in a text | Eduardo | Word VBA | 5 | 06-15-2009 01:55 AM |
Extract from String using Wildcard | whousedmy | Word | 0 | 05-21-2009 01:35 AM |