Ask Your Question
0

Copy cellvalue to end of another?

asked 2019-03-22 02:50:30 +0200

Lika gravatar image

updated 2019-03-22 02:51:23 +0200

Ok have tried for a long time and patience is gone '=) I have 2 columns that I want to merge together to one.

A                  B
20180925    03:00:00
20180925    03:30:00
20180925    04:00:00
20180925    04:30:00
20180925    05:00:00
20180925    05:30:00

Wanted result

A
20180925 03:00:00

I tried merge cells however I have 20000 rows and can not figure out how to merge multiple rows.... Have also tried with =concatenate(a1,b1) but I get error since time is not text???

What to do?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
1

answered 2019-03-22 06:26:52 +0200

Several options.

  1. You may simply select both columns, copy, then paste as Unformatted Text (Ctrl+Alt+Shift+V); make sure that Tab is not checked in the Text Import dialog's Separator Options. Then you may replace tabs with spaces.

  2. If your time column has proper times, not strings, then you may use formula like =A1&" "&TEXT(B1; "HH:MM:SS"). If you need, you may convert the result from formulas to text then, using DataCalculateFormula to Value tool.

edit flag offensive delete link more

Comments

You are a monster eating LibreOffice for breakfast, lunch and dinner! =) Once again a big thank you!

Lika gravatar imageLika ( 2019-03-22 11:31:40 +0200 )edit
0

answered 2019-03-22 05:20:34 +0200

Ratslinger gravatar image

updated 2019-03-22 05:21:06 +0200

Hello,

Using answer from @m.a.riosv from this post as a basis -> how to concatenate 12 hr time and the text "AM" or "PM", try:

=A1&" "&TEXT(B1;"HH:MM:SS")
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-03-22 02:50:30 +0200

Seen: 42 times

Last updated: Mar 22