Question description:
This user has given permission to use the problem statement for this
blog.
I need to delete everything in a column that is between ( and )
Solved by F. W. in 15 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
19/06/2018 - 07:04
Hi…Welcome to Got It Pro
Excelchat Expert
19/06/2018 - 07:04
Could you share a sample of how your data looks like?
User
19/06/2018 - 07:04
yes, stand by
Excelchat Expert
19/06/2018 - 07:05
sure
User
19/06/2018 - 07:06
I want to delete everything in between ( and ) in the column
Excelchat Expert
19/06/2018 - 07:06
Do you mean from column C?
User
19/06/2018 - 07:06
yes
Excelchat Expert
19/06/2018 - 07:07
And does ( this occur just once in the entire string?
User
19/06/2018 - 07:07
yes
Excelchat Expert
19/06/2018 - 07:08
And looks like it always is at the end of the string
User
19/06/2018 - 07:08
correct
Excelchat Expert
19/06/2018 - 07:09
We can do it in 2 ways
Excelchat Expert
19/06/2018 - 07:09
One is without formula, just using Text to column
Excelchat Expert
19/06/2018 - 07:09
Are you familiar with this function?
User
19/06/2018 - 07:09
No.
Excelchat Expert
19/06/2018 - 07:10
ok..let me take you through that
Excelchat Expert
19/06/2018 - 07:10
As you can see I have just copied column C to Column G to manipulate the data
User
19/06/2018 - 07:11
yes
Excelchat Expert
19/06/2018 - 07:12
Now click on column G
Excelchat Expert
19/06/2018 - 07:12
From the main menu, select Data > Split text to column.
Excelchat Expert
19/06/2018 - 07:12
This will prompt you to select the delimiter, Here you can choose custom and type (
Excelchat Expert
19/06/2018 - 07:13
This will split your data and leave only the string before ( in column G
Excelchat Expert
19/06/2018 - 07:13
But I see there is a { also in C8
Excelchat Expert
19/06/2018 - 07:13
So its not consistent
User
19/06/2018 - 07:14
I don't see that opyion under the data tab.. the { can stay
Excelchat Expert
19/06/2018 - 07:14
Your preview screen is small, so you are unable to scroll down.
Excelchat Expert
19/06/2018 - 07:15
https://docs.google.com/spreadsheets/d/1dzcdZbuqBb5rSWvM3tEhonhSA9PGA9v6RH-A9U8vvG0/edit#gid=0
Excelchat Expert
19/06/2018 - 07:15
Please use this link to open this file in your browser
User
19/06/2018 - 07:16
ahhhh ... Google .... Gotcha
User
19/06/2018 - 07:17
Now that I know how to do this, I can edit the file.. THANK YOU !!!!!
Excelchat Expert
19/06/2018 - 07:17
In excel, this function is under the same menu, but little different in executing, but its self explanatory.
Excelchat Expert
19/06/2018 - 07:17
Perfect
Excelchat Expert
19/06/2018 - 07:17
Is there anything else I can help you with this query?
User
19/06/2018 - 07:18
no, thank you for your help!
Excelchat Expert
19/06/2018 - 07:18
Please do give me a good feedback for my service.
Excelchat Expert
19/06/2018 - 07:18
Thanks for your time. Please do come back for any new question. Have a great day ahead!
User
19/06/2018 - 07:18
you too!!
Excelchat Expert
19/06/2018 - 07:18
You can now end this session. Thanks again!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
