• 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.

Identify from text

Dear abhijeet, before proceed further, i just want to ask one thing that, the above sentence "15.12.2013 343 S030.tif" is this was written in any cell in the excel worksheet or this was a file name which was saved in your system.

Please explain
 
if this was your stardard format means rest of the text will same as the format "15.12.2013 343 S030.tif", then u can use =MID(B1,FIND(" ",B1)+1,3)
 
Dear Abhijeet,
If the format is not fix, you should explain, how you want the formula to get your desired result. In the above "15.12.2013 343 S030.tif" we are thinking that first 10 digits (15.12.2013) then your required 3 digits (343), so should adjust/know the position of your required data and some text formulas you can apply.

Otherwise please provide sample data, so that we can know the how many formats you are having
 
@ Balli,

A shorter version to get same result
=MID(A1,FIND(" ",A1)+1,FIND(" ",A1,FIND(" ",A1)+1)-FIND(" ",A1))
 
You must log in or register to reply here.
Back
Top