find and replace

Copper Contributor

Is it possible with find and replace, or some other tool similar, to find all instances of a character- for this example a space- and replace it with a tab? or is there another easy way to shift text over to the proceeding column so that I can expand the text walls that fill these columns into easier to handle data?

1 Reply

@Random_excel_user8764 

Perhaps you can use the Text to Columns command.