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