Thread: select until =
View Single Post
 
Old 01-28-2024, 04:01 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

You haven't told us what you want to do with such a non-contiguous selection so I'm going to suggest a non-VBA way to achieve this.

Does your content have any tables in it? If not, I would select all and Convert Text to Table, using the "=" as the separator. This will give you a two column table with everything before the = in one column and everything after in the second column. Then select the column you want.

You can convert back to text to re-instate the original layout.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote