Please, I need help to write the VBA code required to take out "INC000010542826" out of "APRON_PaymentsLAYOUT Update User JLOVE Occured Audit ID INC000010542826 Comment None". I have almost 700 rows with similar text string.
[b]Split text into different columns with the Convert Text to Columns Wizard[/b] Select the cell or column that contains the text you want to split.[/*]Select Data > Text to Columns.[/*]In the Convert Text to Columns Wizard, select Delimited > Next.[/*]Select the Delimiters for your data. [/*]Select Next.[/*]