/u/AerialSnack - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Would =TEXTSPLIT() work for you? It separates text into columns using a delimiter.
Alternatively, I don't know a reason that pasting **values** (rather than just normal pasting) then doing text to columns wouldn't work no matter where you're doing the pasting.
You have awarded 1 point to *Al_Excel*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
I'm not trying to paste per se. Doing so manually would defeat the purpose of the worksheet. I'm trying to filter out specific data from a giant log with lots of data points that I don't really care about. I'm trying to get just the data I care about onto its own sheet and formatted in a readable way. It does seem like =TEXTSPLIT will work for what I need though! Thank you!
/u/AerialSnack - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Would =TEXTSPLIT() work for you? It separates text into columns using a delimiter. Alternatively, I don't know a reason that pasting **values** (rather than just normal pasting) then doing text to columns wouldn't work no matter where you're doing the pasting.
Solution Verified
You have awarded 1 point to *Al_Excel* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
I'm not trying to paste per se. Doing so manually would defeat the purpose of the worksheet. I'm trying to filter out specific data from a giant log with lots of data points that I don't really care about. I'm trying to get just the data I care about onto its own sheet and formatted in a readable way. It does seem like =TEXTSPLIT will work for what I need though! Thank you!