Ask Your Question
0

Calc: how to add text + A1 + Text ...

asked 2019-05-12 23:04:54 +0100

evx80 gravatar image

Hi

Kindly need help How i can

Text Column Text [sound: + A1,B1 + ]

so it show [sound:abx.mp3]

thanks

edit retag flag offensive close merge delete

Comments

1

Confusing, what do you mean by "Text Column Text [sound: + A1,B1 + ]" ? In general: ="sound:" & A1 & "." & B1 would combine the word "sound:" with text in cell A1, add a dot(".") and any text in B1. But from your description it is absolutely not clear (at least for me) that this is what you requested. Now, if you put "abx" into A1, "mp3" into B1 and the formula ="sound:" & A1 & "." & B1 into cell C1, cell C1 will show "sound:abx.mp3"

Please edit your question, if you are adding additional information. Do not use "Post Your Answer", if you do not answer your own question.

Opaque gravatar imageOpaque ( 2019-05-12 23:14:39 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2019-05-12 23:09:48 +0100

A1= Text A2= 33 A3= text

=A1&A2&A3

or

= "Text "&A2&" text."
edit flag offensive delete link more
0

answered 2019-05-13 01:17:27 +0100

evx80 gravatar image

thank you so much. its work like a charm

="[sound:" & A1 & "]"

the result is [sound:abx.mp3]

edit flag offensive delete link more

Comments

Please use "add a comment", if you are commenting another comment or answer. Thanks in advance.

Opaque gravatar imageOpaque ( 2019-05-13 08:35:10 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-05-12 23:04:54 +0100

Seen: 49 times

Last updated: May 13