Forum Discussion

tonyceccato's avatar
tonyceccato
Icon for Microsoft rankMicrosoft
Jan 23, 2026

Help with a Formula

Below is a formula I created to return specified rows and columns for a sheet named Detail and in the case or column 49 detect if there are comma separated values and explode them into separate colum...
excel
Formulas and Functions
training
tonyceccato's avatar
tonyceccato
Icon for Microsoft rankMicrosoft
Jan 27, 2026

Thank you all for the reply's many of you suggestions helped so now I know where to go to get great Excel Formula advice!!! I ultimately went with a power query to get the results I needed. No need for more replies.  Thank you all again!!!