Hi
I have a cell with string e.g 567/one/111
I want to only extract the text only within the /TEXT HERE/
the string varies so it can 234567/one/12 etc so the length of character varies but the text is always between the /...../
so answer will be one for above NOT /one/ or /one
can you help using formula only not vba?
Last edited by voicetec; 11-15-2013 at 12:27 PM.
Hi voicetec and welcome to the forum.
I would suggest that you upload a sample excel file with 15-20 rows of data so we could see all the variant forms of strings.
On the bottom of the screen press Go Advanced then click on paperclip icon and Add Files.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
I don't actually have all varients..just sample data which i'm going to work.Originally Posted by AlKey
I know the format of characters is
1/one/366
789/three/6754
766/two/22
This is all i have..i'm expecting a huge file next week withe real data that i need to sort. :-(
can we get a formula based on the three above?
Hi Something like this
TRIM(MID(SUBSTITUTE(A1,"/",REPT(" ",99)),99,99))
Excel Guru in the making
<----------If the question has been answered to your satisfication please click the Add Repuation star to the left
Brilliant!! it's works!!!
SOLVED
Thanks for the feedbackAny issues just let me know
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks