Question description:
This user has given permission to use the problem statement for this
blog.
Need to seperate text thats in a cell so i can sum them
Solved by G. C. in 10 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
01/10/2018 - 04:44
Hello
User
01/10/2018 - 04:45
hi buddy
Excelchat Expert
01/10/2018 - 04:45
Can you please provide more details related to the excel issue?
User
01/10/2018 - 04:46
you see this
User
01/10/2018 - 04:47
colkumn b is what raw data i have
User
01/10/2018 - 04:48
i need to seperate the numbers out of it into two comlums
User
01/10/2018 - 04:48
seperate
User
01/10/2018 - 04:48
so i can sum them
Excelchat Expert
01/10/2018 - 04:48
Ok.. so you need to extract the numbers from column B into column D & F
Excelchat Expert
01/10/2018 - 04:48
give me few minutes.. i will build the formula and share..
User
01/10/2018 - 04:48
left numbers into one column right numbers into another
Excelchat Expert
01/10/2018 - 04:50
please validate the formula in column I...
Excelchat Expert
01/10/2018 - 04:50
now working on updating the formula for for second part.
Excelchat Expert
01/10/2018 - 04:52
Please check the formula in column K, this extracts the second part of the numbers
Excelchat Expert
01/10/2018 - 04:52
Hope this solves the excel problem.
User
01/10/2018 - 04:53
Thank you
User
01/10/2018 - 04:53
5 million starts
Excelchat Expert
01/10/2018 - 04:53
I have marked the session as DONE..
Excelchat Expert
01/10/2018 - 04:53
please leave a feedback and rating when you end the session..
Excelchat Expert
01/10/2018 - 04:54
Have a nice day :)
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.