Please help in getting data clubbed in one cell
Solved/Closed
Pkg1403
TrowaD
- Posts
- 2
- Registration date
- Tuesday September 1, 2015
- Status
- Member
- Last seen
- September 1, 2015
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Related:
- Please help in getting data clubbed in one cell
- How to run macro when data entered in a cell - Guide
- Excel copy data into next empty cell - Guide
- Multiple data validation in one cell - Guide
- Make a macro run when data entered in a cell ✓ - Forum - Excel
- Copy data into next empty cell in new sheet ✓ - Forum - Excel
2 replies
TrowaD
Sep 1, 2015 at 11:44 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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
Sep 3, 2015 at 10:55 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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?