Requirement:
- In excel need to get left / right values based on one character. Here we use "="
- In excel need to get left / right values based on one character. Here we use "="
Text
|
LeftFormula
|
LeftValue
|
RightFormula
|
RightValue
|
abcd=123
|
=LEFT(A2,FIND("=",A2,1)-1)
|
abcd
|
=RIGHT(A2,LEN(A2)-FIND("=",A2))
|
123
|
a=1
|
=LEFT(A3,FIND("=",A3,1)-1)
|
a
|
=RIGHT(A3,LEN(A3)-FIND("=",A3))
|
1
|
b=2
|
=LEFT(A4,FIND("=",A4,1)-1)
|
b
|
=RIGHT(A4,LEN(A4)-FIND("=",A4))
|
2
|
c=3
|
=LEFT(A5,FIND("=",A5,1)-1)
|
c
|
=RIGHT(A5,LEN(A5)-FIND("=",A5))
|
3
|
abcde=12345
|
=LEFT(A6,FIND("=",A6,1)-1)
|
abcde
|
=RIGHT(A6,LEN(A6)-FIND("=",A6))
|
12345
|
No comments:
Post a Comment