My first through was, how do I paste in a tab character, or a new line character.. What's the five sequence command to do that. Well, Google Sheets has a much easier way: REGEX.
"\t" is regex for tab, and "\n" for newline.
Find: \n to find newlines Replace with a space, and check regular expressions
Find: \t to find tabs Replace with a space, and ensure regular expressions is checked.
I found a full list of regular expression characters at: https://help.libreoffice.org/Common/List_of_Regular_Expressions
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.