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
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 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

2 replies

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
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
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
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