LinkBack URL
About LinkBacks
The constant is the numbers or number I want to remove are: 0, 2, 5, 6, 7, 9
Example:
A1 the number is 672, so the number left in B1 would be 2.
Or the number in A2 is 938, the numbers left in B2 would be 38.
So on and so forth...
The constant is the numbers or number I want to remove are: 0, 2, 5, 6, 7, 9
Example:
A1 the number is 672, so the number left in B1 would be 2.
Or the number in A2 is 938, the numbers left in B2 would be 38.
So on and so forth...
=if(sumproduct(isnumber(search({0,2,5,6,7,9},a1))*1)=len(a1),right(a1,1),substitute(substitute(substitute(substitute(substitute(substitute(a1,0,""),2,""),5,""),6,""),7,""),9,""))
try this
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Usually you can nest Substitute functions, but I prefer UDF since it is more flexible.
Please Login or Register to view this content.
Or below
Please Login or Register to view this content.
Thanks for the quick response...it works!
You are welcome and thanks for your feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks