find and replace

%3CLINGO-SUB%20id%3D%22lingo-sub-2661009%22%20slang%3D%22en-US%22%3Efind%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2661009%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20with%20find%20and%20replace%2C%20or%20some%20other%20tool%20similar%2C%20to%20find%20all%20instances%20of%20a%20character-%20for%20this%20example%20a%20space-%20and%20replace%20it%20with%20a%20tab%3F%20or%20is%20there%20another%20easy%20way%20to%20shift%20text%20over%20to%20the%20proceeding%20column%20so%20that%20I%20can%20expand%20the%20text%20walls%20that%20fill%20these%20columns%20into%20easier%20to%20handle%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2661009%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2661089%22%20slang%3D%22en-US%22%3ERe%3A%20find%20and%20replace%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2661089%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1131457%22%20target%3D%22_blank%22%3E%40Random_excel_user8764%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20can%20use%20the%20%3CA%20href%3D%22https%3A%2F%2Fwww.excel-easy.com%2Fexamples%2Ftext-to-columns.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EText%20to%20Columns%3C%2FA%3E%20command.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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.