Forum Discussion
lnjohnson
Jun 07, 2023Copper Contributor
Identify characters and split into different sheets
How do i create a formula that scans a column, auto-identify similar characters(perhaps by first 3 characters) in a cell and then splits(extract) the cells with similar characters into different shee...
- Jun 14, 2023
Success! I was able to use ChatGPT and it produced the following code. I had to ask it separately for the match code, then paste it into the original code, but it works perfectly now. Thanks:
NikolinoDE
Jun 13, 2023Gold Contributor
is this in the right direction, does it fit? ...see file.
If not, please explain exactly (step by step, cell by cell, sheet by sheet) exactly what is to be done. If possible, include a file (without sensitive data) or photos. Additional information such as Excel version, operating system, storage medium would be an advantage. Thank you for your understanding.
lnjohnson
Jun 13, 2023Copper Contributor
Thank you for responding. The idea is that the cell information starts the way you have listed in your document. Then the formula should divide the cell information into different sheets based on the first three characters of each cell. See attachment.