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
Please inform how to get the following information clubbed in a row

Data as follows Required data in a One cell

22 44 6505 A45 22:44:6505:A45
Related:

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
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
0
Pkg1403 Posts 2 Registration date Tuesday September 1, 2015 Status Member Last seen September 1, 2015
Sep 1, 2015 at 12:29 PM
Thanks for reply, but sir, I don't require splitting of data, I explain again
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?
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
0