New

Splitting text

  Excel
KennyO
  KennyO
  Wednesday, 05 August 2020
  1 Replies
  9.7K Visits
0
Votes
Undo
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.
0
Oldest First  
mikeduke1290
mikeduke1290
3 years ago
·
#2167
0
Votes
Undo
[b]Split text into different columns with the Convert Text to Columns Wizard[/b]
  1. Select the cell or column that contains the text you want to split.[/*]
  2. Select Data > Text to Columns.[/*]
  3. In the Convert Text to Columns Wizard, select Delimited > Next.[/*]
  4. Select the Delimiters for your data. [/*]
  5. Select Next.[/*]
  • Page :
  • 1
There are no replies made for this post yet.