**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.*