Note: The other languages of the website are Google-translated. Back to English
English English
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Wednesday, 05 August 2020
  1 Replies
  4.8K 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.
2 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.