find: . (or whatever)
replace: ^p
Merge (and UN- Merge) Cells with Data
https://support.office.com/en-us/article/split-a-cell-f1804d0c-e180-4ed0-a2ae-973a0b7c6a23
To get just the FIRST 3 characters of a cell :
=LEFT(A1,3)
To get everything AFTER the first 3 characters of a cell :
=IFERROR(RIGHT(A1,LEN(A1)-3),“”)
To get the LAST 3 Charcters
=RIGHT(A1,3)
https://stackoverflow.com/questions/49850210/excel-formula-to-split-cell-text-based-on-char-count
The steps :
REMOVE DUPLICATES FROM A COLUMN IN EXCEL
Select the range of cells that has duplicate values you want to remove.
Tip: Remove any outlines or subtotals from your data before trying to remove duplicates.
Click Data > Remove Duplicates, and then Under Columns, check or uncheck the columns where you want to remove the duplicates.