Pasting text into Excel without splitting on spaces (or other delimiter)
Pasting text into Excel without splitting on spaces (or other delimiter)
Pasting text into Excel without splitting on spaces (or other delimiter)
Re: Pasting text into Excel without splitting on spaces (or other delimiter)
This seemed to work, but is a bit involved.
- Enter data into a cell.
- Select the Text to Columns feature.
- Make sure Delimited is selected and choose Next.
- Uncheck the check next to Space (or the delimiter you want to disable)
- Click Finish.
- Enter data into a cell.
- Select the Text to Columns feature.
- Make sure Delimited is selected and choose Next.
- Uncheck the check next to Space (or the delimiter you want to disable)
- Click Finish.