URGENT: Specific excel cell filtering

[kjijujoseph]

I am in need of a step by step help on the query below.

In an excel sheet, I need to first find out cells which contains the symbol '[' and delete all the characters which is before that irrespective of the character numbers. The cells are just text values and no formulas. How do we do that?

Note: I am not an excel expert. So request a step by step guidance on this.

[dilipandey]

Hi Kjijujoseph,

Welcome to the forum.

You can use the below formula:-

=IFERROR(MID(A1,SEARCH("[",A1)+1,LEN(A1)),A1)
character after bracket sign.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[Cutter]

To remove the data from every cell on the sheet you can do it in one go.
Ctrl+H brings up the Find / Replace window
In the Find field type this: *[
In the Replace field type: [
Now click the Replace All button