Excel – Search for a character from the right

4 May, 2016 at 9:49 am Leave a comment

I want to extract “12C2” in string “D_CI-CC____-MY-12C2”

(1) Find position of “-” from the right: MATCH(“-“,INDEX(MID(A1,LEN(A1)-ROW(INDIRECT(“1:”&LEN(A1)))+1,1),0),0)

(2) Extract “12C2”: =RIGHT(A1, MATCH(“-“,INDEX(MID(A1,LEN(A1)-ROW(INDIRECT(“1:”&LEN(A1)))+1,1),0),0)-1)

Entry filed under: IT/Soft. Tags: .

(Phim) Hậu duệ mặt trời The 82 Commandments of Alejandro Jodorowsky

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


May 2016
M T W T F S S
« Apr   Jun »
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Categories


%d bloggers like this: