Another
=MID(A2,7,6)*1
The *1 converts the result into numeric so it can be omitted if you don't need that.
The 6 can be any number >= the number of characters needed. So you can use, say, 50 if you have varying lengths of strings.
Another
=MID(A2,7,6)*1
The *1 converts the result into numeric so it can be omitted if you don't need that.
The 6 can be any number >= the number of characters needed. So you can use, say, 50 if you have varying lengths of strings.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks