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 January 16, 2023 - Sep 3, 2015 at 10:55 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - 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
- Digital data transmission - Guide
- How to be offline in whatsapp when data is on - Guide
- If cell contains specific text then return value in another cell vba ✓ - Excel Forum
2 replies
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
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
January 16, 2023
547
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?