Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 05 August 2020
  1 Replies
  9K 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.
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.