alfredpleb Posted September 23, 2018 Share Posted September 23, 2018 Hi. I have a spreadsheet that I am copying multiple cells into another sheet- but I'd like it in just 1 cell. What I've been doing is using Clean Text to remove returns from the app, but if I could run a shortcut to remove returns from my clipboard it would save me the steps of pasting into Clean Text, clicking remove returns, and copying that text. Link to comment
vitor Posted September 23, 2018 Share Posted September 23, 2018 So you have Some text like this and want to make it (replace newlines with spaces) Some text like this or (remove newlines) Sometext likethis ? Link to comment
alfredpleb Posted September 23, 2018 Author Share Posted September 23, 2018 (edited) Some text like this Hi. I have text like this, and when I paste it into an excel or google sheet, it becomes multiple cells. I'd like to strip the returns so that it all goes into one cell. Here is a more detailed example of what I am wanting to strip into plain text that doesn't have returns: Some text: text Some text 2: Text Some text 3: text Some text 4: text Some text 5: text Edited September 23, 2018 by alfredpleb Link to comment
vitor Posted September 23, 2018 Share Posted September 23, 2018 Here’s a Workflow with both options. alfredpleb 1 Link to comment
alfredpleb Posted September 23, 2018 Author Share Posted September 23, 2018 5 minutes ago, vitor said: Here’s a Workflow with both options. Thank you, this works great. vitor 1 Link to comment
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now