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

**DonkeyOte** · 09-21-2009, 04:25 AM

shg, did you mean to use MID ?

other alternatives might be:

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

or

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

**Shijesh Kumar** · 09-21-2009, 04:29 AM

One more method..

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

Select Delimited radio button.

In others type ]

Click on OK...

**shg** · 09-21-2009, 10:45 AM

shg, did you mean to use MID ?

I did, thank you, DO

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