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
- Excel - Copy data into next empty cell in new sheet - 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
- 2674
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- October 27, 2020
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
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?