Related:
- Please help in getting data clubbed in one cell
- Excel - A Macro to copy and paste data in next blank cell - How-To - Excel
- Excel - Run macro when data entered in a cell - How-To - Excel
- Multiple data validation in one cell - How-To - Excel
- 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
- Posts
- 2829
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- November 22, 2021
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
- 2829
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- November 22, 2021
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
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?