💻 Software
Copy data with comma into single column in excel?
Fresh5 days ago
Mar 15, 202642639 viewsConfidence Score0%
0%
Problem
How can I copy and paste multiple rows of data that contains a comma, such as into a single column in Excel 2007? The default behavior seems to be to split the data into two columns.
Error Output
LastName, FirstName
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Copy data with comma into single column in excel?
Low Risk
Use the text importation wizard instead of pasting the data (Data -> Obtain External Data -> From text) Edit: I found out that, after using the Text to Columns wizard with the comma option enabled, the results persist to copy-paste, as C. Ross point…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix