Note: The other languages of the website are Google-translated. Back to English
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
  5.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.

Follow Us

Copyright © 2009 - www.extendoffice.com. | All rights reserved. Powered by ExtendOffice. | Sitemap
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Protected by Sectigo SSL