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

“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 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 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
When I past a line of text into excel, where there is a space, it puts the data in to a separate column. Can you assist?
Solved by S. B. in 13 mins
I need a formula to separate the type of a column when cells contain different text.
Solved by V. H. in 25 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