Please help in getting data clubbed in one cell [Solved/Closed]

Report
Posts
2
Registration date
Tuesday September 1, 2015
Status
Member
Last seen
September 1, 2015
-
Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
-
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

2 replies

Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
446
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
Posts
2
Registration date
Tuesday September 1, 2015
Status
Member
Last seen
September 1, 2015

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?
Posts
2674
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 27, 2020
446
Hi Pkg,

For that use the following formula in column 5:
=A1&":"&B1&":"&C1&":"&D1


Best regards,
Trowa