Get instant live expert help on how to separate 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
I am using Excel for Mac 2016. I want to add data to a column and then use text to columns to separate it. My problem, the text to columns window for setting the column breaks is too narrow and I don't know how to navigate further to the right. It was intuitive in Excel 2011. Not now.
Solved by X. A. in 15 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
How to count cells incldes text in excel
Solved by E. J. in 24 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