How Can I Remove Everything to the Left of...

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

You quit trying too soon.

=RIGHT(A1, FIND("]", A1) + 1, 1024)

shg, did you mean to use MID ?

other alternatives might be:

=RIGHT(A1,LEN(A1)-FIND("]",A1))

or

=REPLACE(A1,1,FIND("]",A1),"")

One more method..


Select the column..
Click on Data--> Text to column

Select Delimited radio button.

In others type ]

Click on OK...

shg, did you mean to use MID ?

I did, thank you, DO