Copy and paste spaces inbetween data into a range
Closed
PeteMohr
-
Updated on Mar 27, 2018 at 10:28 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Mar 27, 2018 at 11:47 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Mar 27, 2018 at 11:47 AM
Related:
- Copy and paste spaces inbetween data into a range
- Tmobile data check - Guide
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as named ranges. ✓ - Excel Forum
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- How to reset safe folder password without losing data ✓ - Android Forum
- Copy range data in a column to new column. ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Mar 27, 2018 at 11:47 AM
Mar 27, 2018 at 11:47 AM
Hi PeteMohr,
' it pastes all the information into cell A1 '
Usualy when you paste data over to Excel, all the data is pasted in column A. So the rows are there but the column are not. Is this the case with you or did it really paste all the data in one cell A1?
'There are 2,899 registrations'
' need them to be listed into rows of 11'
'The range would therefore be A1:J2,900'
So I guess instead of rows you mean columns. But then you would end up with column K instead of J. Kind of confusing.
Are you familiar with the text delimiter option? You can find it under the Data tab. It will let you spread your data across columns based on spaces (amongst other options).
Best regards,
Trowa
' it pastes all the information into cell A1 '
Usualy when you paste data over to Excel, all the data is pasted in column A. So the rows are there but the column are not. Is this the case with you or did it really paste all the data in one cell A1?
'There are 2,899 registrations'
' need them to be listed into rows of 11'
'The range would therefore be A1:J2,900'
So I guess instead of rows you mean columns. But then you would end up with column K instead of J. Kind of confusing.
Are you familiar with the text delimiter option? You can find it under the Data tab. It will let you spread your data across columns based on spaces (amongst other options).
Best regards,
Trowa
