Forum Discussion
Text to columns
We are migrating from one database to another. I have a customer spreadsheet with an address block which is all in 1 column but separated by line breaks that needs splitting into 6 columns. When you ...
Actually, I read somewhere else that Excel can't handle a line break in the cells, so you can search and replace for Ctrl J and Alt-Enter to get rid of those, still not my entire problem but getting closer.
Hello Sarah, could you provide some of your data to be able to perform an analysis here. Without the original data that does not work, it can not work.
If you can't share documents here, then please use another file sharing service and post the link here.
BTW: What is CTRL+ J for a shortcut. Where does it do something? Is it a character or formatting in a program? Is it from the Mac? It doesn't seem to do anything in Excel on Windows.