Ask Your Question

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

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

evx80 gravatar image


Kindly need help How i can

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

so it show [sound:abx.mp3]


edit retag flag offensive close merge delete



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

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

A1= Text A2= 33 A3= text



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

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


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


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

Seen: 49 times

Last updated: May 13