• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find out numeric data

R

Rahul Mishra

Member
Mixed DataDesired Output
erfsd9958405019e349958405019
5353w9810105370qw435 9810105370
ewrew8860339000dfdf8860339000
erfsd9873903709sds49873903709
ewrew9810241172-359810241172
edsd9582121827dfd359582121827
rdf9999377066dfs5fd9999377066
wer9873744954df439873744954
53sdf9818803734adf4439818803734
45df9266494491sfg9266494491
rew8459022058gd8459022058
fs8447060022adf4538447060022
 
Duplicate post..

Check this..

=--MID(A2,MATCH(TRUE,ISNUMBER(--MID(A2,ROW($1:$99),10)),0),10)

with CSE
 
You must log in or register to reply here.
Back
Top