Question description:
This user has given permission to use the problem statement for this
blog.
hi,
I have got a that contains the list information of my customer in a single column containing other unusefull info. I want to separate the name email Telefon-Nummer and time from that data.
Can you please help
Solved by S. D. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
09/12/2017 - 05:27
plz say hi if u are there
Excelchat Expert
09/12/2017 - 05:27
Welcome, Thanks for choosing Got It Pro-Excel
How may I help you today?
Excelchat Expert
09/12/2017 - 05:28
Can you upload a sample for me?
User
09/12/2017 - 05:28
have done that
Excelchat Expert
09/12/2017 - 05:28
I see that the file is a Google Sheets
Excelchat Expert
09/12/2017 - 05:28
Can you download it and upload it here for me to work on it?
User
09/12/2017 - 05:29
data is quite sensitive
User
09/12/2017 - 05:29
so I would like if u could do it on this much
User
09/12/2017 - 05:29
that i have uploaded
Excelchat Expert
09/12/2017 - 05:29
Let me see if the formula works in google sheets
User
09/12/2017 - 05:29
okie
Excelchat Expert
09/12/2017 - 05:30
You need the email id
Excelchat Expert
09/12/2017 - 05:30
Telephone number
User
09/12/2017 - 05:30
i need name email telefon and time
Excelchat Expert
09/12/2017 - 05:31
The data is not properly formatted to run the formula
Excelchat Expert
09/12/2017 - 05:31
There is no uniformity in the data
Excelchat Expert
09/12/2017 - 05:31
I will need a little more time to figure out
User
09/12/2017 - 05:31
okie
Excelchat Expert
09/12/2017 - 05:32
Is the data you are working with , larger in size than what is currently uploaded?
User
09/12/2017 - 05:32
yes
User
09/12/2017 - 05:33
its just the sample
User
09/12/2017 - 05:35
r u still working on it
Excelchat Expert
09/12/2017 - 05:35
It is very unorganised to be called a complete data that can be worked on, virtually it is impossible to arrange such data , however I have an add on that might help.
Excelchat Expert
09/12/2017 - 05:35
Let me use it and get back to you
User
09/12/2017 - 05:36
okie
User
09/12/2017 - 05:36
if u can tell me only one thing
User
09/12/2017 - 05:36
rest i can do
Excelchat Expert
09/12/2017 - 05:37
Can you download Kootools
User
09/12/2017 - 05:37
can you please tell me how to remove the other unwanted cells that i dont need
Excelchat Expert
09/12/2017 - 05:37
Its an add on for excel and will do your work
Excelchat Expert
09/12/2017 - 05:38
Kootools is an add on for excel and you will find it in excel
Excelchat Expert
09/12/2017 - 05:38
And it will make it easier for you to work on this problem
User
09/12/2017 - 05:39
okie thanks
Excelchat Expert
09/12/2017 - 05:39
tanishasingh2016@sg2plcpnl0240.prod.sin2.secureserver.net
jeet.bhatia972@gmail.com
harald.wolter.bmis@t-online.de
Multi Email Forward For Gmail
tanishasingh2016@sg2plcpnl0240.prod.sin2.secureserver.net
jeet.bhatia972@gmail.com
Multi Email Forward For Gmail
tanishasingh2016@sg2plcpnl0240.prod.sin2.secureserver.net
jeet.bhatia972@gmail.com
heiko.strutz.bmis@t-online.de
tanishasingh2016@sg2plcpnl0240.prod.sin2.secureserver.net
jeet.bhatia972@gmail.com
tanishasingh2016@sg2plcpnl0240.prod.sin2.secureserver.net
jeet.bhatia972@gmail.com
bijan.mihan@gmail.com
Excelchat Expert
09/12/2017 - 05:39
Just used Kootools to extract the email ids
Excelchat Expert
09/12/2017 - 05:39
If you can share the excel file with the info, I can do it for you
Excelchat Expert
09/12/2017 - 05:40
Also make sure to read our Privacy Policy
Excelchat Expert
09/12/2017 - 05:40
We don't store your files offline
Excelchat Expert
09/12/2017 - 05:41
Also Extracted the phone numbers
Excelchat Expert
09/12/2017 - 05:41
17660884638
17624761204
1774444181
Excelchat Expert
09/12/2017 - 05:43
Also extracted Time
Excelchat Expert
09/12/2017 - 05:43
Tue, 23 May 2017 01:06:53 -0700 (PDT)
Tue, 23 May 2017 01:08:02 -0700 (PDT)
Tue, 23 May 2017 01:09:23 -0700 (PDT)
Tue, 23 May 2017 01:10:26 -0700 (PDT)
Tue, 23 May 2017 01:48:47 -0700 (PDT)
Excelchat Expert
09/12/2017 - 05:43
Is there anything else you want to know regarding this issue?
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.
