Ask Your Question
0

Calc, =SUBSTITUTE (...) results in error. Why ?

asked 2016-09-05 16:43:13 +0200

ROSt52 gravatar image

LibO 5.1.3.2

Cell A1 contains:

textstring(a)textstring

I want to replace "(a)" by "@"

Formula used in cell B1:

=SUBSTITUTE(A1,(a),@,1)

I am using comma as separators and created the formula with the wizard

Result:

#NAME?

which is "invalid name"

The string in A1 is text, verified by adding text "(a)@" using the formula:

=A1&"(a)@"

Result:

textstring(a)textstring(a)@

which is correct.

What is wrong? What do I need to do?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-09-05 17:01:36 +0200

Ratslinger gravatar image
=SUBSTITUTE(A1,"(a)","@",1)
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-09-05 16:43:13 +0200

Seen: 102 times

Last updated: Sep 05 '16