Hi All,
I have a Excel Column
e..g A1 = QT33865A1 8C1234 D3
--> I only want 8C1234 to show on B1 ( next column)
How do I only extract the middle portion? ( Between spaces)
Any help is appreciated!
Regards,
Niron
Hi All,
I have a Excel Column
e..g A1 = QT33865A1 8C1234 D3
--> I only want 8C1234 to show on B1 ( next column)
How do I only extract the middle portion? ( Between spaces)
Any help is appreciated!
Regards,
Niron
Hi niron,
Use below formula in B1:-
Formula:Please Login or Register to view this content.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Thanks DILIPandey!
You Rock! it works like magic! I'll update as solved.
Best Regards,
Niron
If the code is always of equal length you would use
But I suspect that is not the case. To extract the string between the first and second space in a string where the space position is not predefined you would usePlease Login or Register to view this content.
Please Login or Register to view this content.
Oops too slow - ignore me!
Or
=MID(A1,FIND(" ",A1)+1,SUM(FIND({"^"," "},SUBSTITUTE(A1," ","^",2))*{1,-1})-1)
You are welcome niron
Cheers
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks