I have a table with 360,000 rows and approximately 26 columns. The first column header/label is called "Division"; it also happens to be the first/left-most column.
Where a cell within the "Division" column starts with the text "Ext" or "ext", possibly followed by more characters, spaces, dashes, etc., I would like to copy the values and formatting from Column 3, named "Group" and paste the values and formatting in Column 2,named "RevisedDivision". If the cell text in the "Division" column doesn't begin with "Ext" or "ext", then simply copy the values from the "Division" column to Column 2 ("RevisedDivsion".) I have seen this performed using the Case "function, but have not been able to replicate it.


Thank you for reading and any help!

I have also posted this here, but have only received one response after several hours. Thank you again!
Change the text within a cell to the text within another cell and paste in another column