View Single Post
 
Old 07-01-2022, 10:04 AM
jeffreybrown jeffreybrown is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

This could be built into the code, but the easiest method would be to use Text to Columns

Text to Columns
  • Highlight range to convert
  • Data >> Data Tools >> Text to Columns >> Check Delimited >> Next
  • Check Space >> Finish >> OK
Reply With Quote