Forum Discussion

lnjohnson's avatar
lnjohnson
Copper Contributor
Jun 07, 2023
Solved

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...
  • lnjohnson's avatar
    lnjohnson
    Jun 14, 2023

    NikolinoDE 

    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:

     

Resources