Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

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
2776
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 26, 2021
 -
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

Answer 1 / 2
Posts
2776
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 26, 2021
 465
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
Report
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?
Answer 2 / 2
Posts
2776
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 26, 2021
 465
Hi Pkg,

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


Best regards,
Trowa
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!