Get instant live expert help on I need help with separate numbers from text in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I am using the text to columns function to separate text from one column . Part of the text in that column is a phone number Unfortunately excel then removes the zero from each of the phone numbers . How do I resolve this ?
Solved by X. S. in 13 mins
What formula can I use to first separate a number from a string of text and then to add the sales attributed to the numbers that are the same?
Solved by B. L. in 25 mins
I need to separate my columns in excel. I see text to columns however on my excel sheet I need to separate the columns by all uppercase letters from sentence case words. Is there a way to do this?
Solved by Z. E. in 19 mins
I'm trying to separate or delete specific text from a cell
Solved by F. J. in 30 mins
Hello, I have two separate sentences written in two separate cells (A1 & B1). If in another cell the answer to a question is 'Client' or 'PDI' for example. I want a formula that will select the correct text from either cell A1 or B1. i.e. 'Client' - Pulls text from A1. If PDI - Pulls text from B1
Solved by V. Y. in 14 mins