LinkBack URL
About LinkBacks
Ocean Zhang 
I need a formula that can remove all characters to the right of "]"
for example, if a1 = abcdefg]1234, I want b1 to return the value: 1234
I tried =RIGHT(a1,FIND("]",a1)-1), but that didn't really work. It returned: fg]1234
I need a formula that can remove all characters to the right of "]"
for example, if a1 = abcdefg]1234, I want b1 to return the value: 1234
I tried =RIGHT(a1,FIND("]",a1)-1), but that didn't really work. It returned: fg]1234
Last edited by Ocean Zhang; 09-22-2009 at 08:44 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks