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.
I created a quick Macro and added it to my personal.xlsm file. Here is the code. This more or less does the same thing that Leigh Riffel has suggested except it is a quick Macro run.
Sub DisableAutoSplitting()
Selection.TextToColumns Destination:=Range("C2"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 1), TrailingMinusNumbers:=True
End Sub