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!”
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