Note: The other languages of the website are Google-translated. Back to English
  Wednesday, 05 August 2020
  1 Replies
  4.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.
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