Please help in getting data clubbed in one cell
Solved/Closed
Pkg1403
Posts
2
Registration date
Tuesday September 1, 2015
Status
Member
Last seen
September 1, 2015
-
Sep 1, 2015 at 11:37 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 3, 2015 at 10:55 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 3, 2015 at 10:55 AM
Related:
- Please help in getting data clubbed in one cell
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Display two columns in data validation list but return only one - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Data transmission cable - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Sep 1, 2015 at 11:44 AM
Sep 1, 2015 at 11:44 AM
Hi Pkg,
There is an option called Text to Columns (found under the Data ribbon).
This will let you spread your single cell data across columns, by splitting the data where a "space" is.
Best regards,
Trowa
There is an option called Text to Columns (found under the Data ribbon).
This will let you spread your single cell data across columns, by splitting the data where a "space" is.
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Sep 3, 2015 at 10:55 AM
Sep 3, 2015 at 10:55 AM
Hi Pkg,
For that use the following formula in column 5:
=A1&":"&B1&":"&C1&":"&D1
Best regards,
Trowa
For that use the following formula in column 5:
=A1&":"&B1&":"&C1&":"&D1
Best regards,
Trowa
Sep 1, 2015 at 12:29 PM
In col1,2,3,4 there is data let us say 22,44,55,66.after that I want in column 5 of same row Data should automatically come as 22:44:55:66.
HOW TO DO THIS?