URGENT: Specific excel cell filtering

jjoseph

New member
Joined
Jun 3, 2012
Messages
3
Reaction score
0
Points
0
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.
 

jjoseph

New member
Joined
Jun 3, 2012
Messages
3
Reaction score
0
Points
0
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.
 

tommyt61

New member
Joined
Mar 26, 2011
Messages
153
Reaction score
0
Points
0
Are these Cells that contain a [ in a column or are they spread out randomly throughout the sheet ?
 

tommyt61

New member
Joined
Mar 26, 2011
Messages
153
Reaction score
0
Points
0
If you can be more specific about how your sheet is layed out , we might can find a solution.
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Go to Edit|Replace

or Home| Find & Select | Replace

or hit CTRL+H

Enter in Find What box: *[

If you want to remove the [ also, then leave the Replace With box empty, otherwise enter a [ in the Replace With box.

then click Replace All.
 

Jon von der Heyden

New member
Joined
Mar 25, 2011
Messages
24
Reaction score
0
Points
0
Location
Stellenbosch,South Africa
Website
www.exceldesignsolutions.com
Hi

NBVC has provided you with a manual solution here.

If it's a VBA solution you are after, you could record the manual process offered by NBVC, although I would be inclined to go with an Evaluate(formula) method.

Code:
Public Sub Demo()
    If TypeName(Selection) = "Range" Then
        With Intersect(ActiveSheet.UsedRange, Selection)
            .Value = Evaluate("IF(ROW(),MID(" & .Address & ",FIND(""[""," & .Address & ")+1,255))")
        End With
    End If
End Sub
 

Simon Lloyd

Administrator
Joined
Apr 2, 2011
Messages
401
Reaction score
0
Points
0
Location
Manchester, England
Excel Version(s)
Excel 2016
@kjijujoseph Please only post your question in one forum, no matter how urgent it is!

Threads merged!
 
Top