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 ...
Two steps:
1) Select cells you need to fix
Then select Find & Replace (Ctrl+f)
Select Replace Tab
fill "Find what:" and put there Ctrl+j
fill "Replace with:" and put there example $$ or something what is not appearing in cell data
Select "Replace All"
2) Now use "Text to Columns" and Delimited and Other. Fill it with $$ or something what you select on "Replace with"
1) Select cells you need to fix
Then select Find & Replace (Ctrl+f)
Select Replace Tab
fill "Find what:" and put there Ctrl+j
fill "Replace with:" and put there example $$ or something what is not appearing in cell data
Select "Replace All"
2) Now use "Text to Columns" and Delimited and Other. Fill it with $$ or something what you select on "Replace with"