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.[/*]
There are no replies made for this post yet.
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »