Get instant live expert help on I need help with excel separate text into columns
“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 a cell into first name last name and email but using "text to columns" is not working
Solved by S. F. in 29 mins
I need to separate a lot of data in one column into separate columns. The Text to Columns function is not sufficient enough for this task and I need to know what I am missing.
Solved by X. U. in 23 mins
I have copied information over from a pdf file on to excel. The PDF file showed separate columns of information but when I copy to excel, all of this information is put into 1 cell and I want to separate the information into separate columns
Solved by E. E. in 18 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
Changing quantitative values into text (created separate text sheet which was melded with data sheet using IF formula into 3rd sheet that now includes 0 values as well as transformed text. Now I need to remove all zeros to sum columns into one text result. Need to make the zero removal automatic going forward. If there was a way to use IF formulas to substitute text for numbers without creating 0's for those columns that didn't have a corresponding number value, that would be ideal. Can you help?
Solved by K. B. in 15 mins