Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

The problem is that the space is 00a0 no-break space, not an ordinary space. So you must use that value in the SUBSTITUTE expression as well.

The problem is that the space is 00a0 no-break space, not an ordinary space. So you must use that value in the SUBSTITUTE expression as well.

Here's my attempt to get it to show correctly in this wiki markup.

=SUBSTITUTE(C5,"Find A Grave Memorial no. ","{{FindAGrave|")

The problem is that the space is 00a0 no-break space, not an ordinary space. So you must use that value in the SUBSTITUTE expression as well.

Here's my attempt to get it to show correctly in this wiki markup.

=SUBSTITUTE(C5,"Find A Grave Memorial no. ","{{FindAGrave|")
no. ","{{FindAGrave|")

The problem is that the space is 00a0 no-break space, not an ordinary space. So you must use that value in the SUBSTITUTE expression as well.

Here's my attempt to get it to show correctly in this wiki markup.

=SUBSTITUTE(C5,"Find A Grave Memorial no. ","{{FindAGrave|")
no. ","{{FindAGrave|")

The problem is that the space is 00a0 no-break space, not an ordinary space. So you must use that value in the SUBSTITUTE expression as well.

Here's OK, here's my attempt to get it to show correctly in this wiki markup.markup based on https://www.w3.org/International/questions/qa-escapes.

=SUBSTITUTE(C5,"Find A Grave Memorial no. ","{{FindAGrave|")

The problem is that the space is 00a0 no-break spaceNO-BREAK SPACE, not an ordinary space. So you must use that value in the SUBSTITUTE expression as well.

OK, here's my attempt to get it to show correctly in this wiki markup based on https://www.w3.org/International/questions/qa-escapes.

=SUBSTITUTE(C5,"Find A Grave Memorial no. ","{{FindAGrave|")

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. So you must use that value in the SUBSTITUTE expression as well.

OK, here's my attempt to get it to show correctly in this wiki markup based on https://www.w3.org/International/questions/qa-escapes.

=SUBSTITUTE(C5,"Find A Grave Memorial no. ","{{FindAGrave|")
no. ","{{FindAGrave|")

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. So you must use that value in the SUBSTITUTE expression as well.

OK, here's my attempt to get it to show correctly in this wiki markup based on https://www.w3.org/International/questions/qa-escapes.

=SUBSTITUTE(C5,"Find A Grave Memorial no. ","{{FindAGrave|")

no. ","{{FindAGrave|")

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. So you must use that value in the SUBSTITUTE expression as well.

OK, here's my attempt to get it to show correctly in this wiki markup based on https://www.w3.org/International/questions/qa-escapes.

=SUBSTITUTE(C5,"Find A Grave Memorial no. ","{{FindAGrave|")

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. So you must use that value in the SUBSTITUTE expression as well.

OK, here's my attempt to get it to show correctly in this wiki markup based on https://www.w3.org/International/questions/qa-escapes.

=SUBSTITUTE(C5,"Find A Grave Memorial no. ","{{FindAGrave|")

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. So you must use that value To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression as well.expression.

OK, here's This wiki is rejecting all of my attempt to get it to show correctly in this wiki markup based on https://www.w3.org/International/questions/qa-escapes.attempts at posting a literal value, so hopefully, you understand what I mean.

=SUBSTITUTE(C5,"Find A Grave Memorial no. ","{{FindAGrave|")

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

This wiki is rejecting all of my attempts at posting a literal value, so hopefully, you understand what I mean.mean. Well, you can do what I did -- Click on "edit" below my answer and then copy the following. (Not sure if that requires karma points or not).

=SUBSTITUTE(F7;"Find A Grave Memorial no. 37178905";"{{FindAGrave|37178905}}")

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

This wiki is rejecting all of my attempts at posting a literal value, so hopefully, you understand what I mean. Well, you can do what I did -- Click on "edit" below my answer and then copy the following. following from the edit box. (Not sure if that requires karma points or not).

=SUBSTITUTE(F7;"Find A Grave Memorial no. 37178905";"{{FindAGrave|37178905}}")

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space.

This wiki is rejecting all of my attempts at posting a literal value, so hopefully, you understand what I mean. Well, you can do what I did -- Click on "edit" below my answer and then copy the following from the edit box. (Not sure if that requires karma points or not).

=SUBSTITUTE(F7;"Find A Grave Memorial no. 37178905";"{{FindAGrave|37178905}}")

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space.space. You might want to use Find & Replace to fix all occurrences.

This wiki is rejecting all of my attempts at posting a literal value, so hopefully, you understand what I mean. Well, you can do what I did -- Click on "edit" below my answer and then copy the following from the edit box. (Not sure if that requires karma points or not).

=SUBSTITUTE(F7;"Find A Grave Memorial no. 37178905";"{{FindAGrave|37178905}}")

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

This wiki is rejecting all of my attempts at posting a literal value, so hopefully, you understand what I mean. Well, you can do what I did -- Click on "edit" below my answer and then copy the following from the edit box. (Not sure if that requires karma points or not).

=SUBSTITUTE(F7;"Find A Grave Memorial no. 37178905";"{{FindAGrave|37178905}}")

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki.

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki.wiki. It always gets converted to 0x20.

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It always gets converted to 0x20.

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to 0x20., for example: my NBSP: ( ).

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to 0x20, for example: my NBSP: ( ).

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to 0x20, for example: example ( ).

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to the ordinary space 0x20, for example like this ( ).

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to the an ordinary space 0x20 like this ( ).

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to an ordinary space 0x20 like this - ( ).

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to an ordinary space 0x20 - for example ( ).

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to an ordinary space 0x20 - , for example ( ).

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to an ordinary space 0x20, space, for example ( ).

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to an ordinary space, for example space. For example, ( ).

The problem is that the space is 00a0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to 0x20, an ordinary space. For example, ( ).

The problem is that the space is 00a0 0xA0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to 0x20, an ordinary space. For example, ( ).

The problem is that the space is 0xA0 U+00A0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to 0x20, an ordinary space. For example, ( ).

The problem is that the space is U+00A0 0xA0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to 0x20, an ordinary space. For example, ( ).

The problem is that the space is 0xA0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

The underlying code point can be seen in Calc by clicking in the input line after the space and then pressing Alt+x.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to 0x20, an ordinary space. For example, ( ).

The problem is that the space is 0xA0 NO-BREAK SPACE, not an ordinary space. To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

The underlying code point can be seen in Calc by clicking in the input line after the space and then pressing Alt+x.

To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to 0x20, an ordinary space. For example, ( ).

The problem is that the space is 0xA0 NO-BREAK SPACE, not an ordinary space. The underlying code point can be seen in Calc by clicking in the input line after the space and then pressing Alt+x.. Requires a recent version, maybe LO 5.1 or higher.

To fix it, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to 0x20, an ordinary space. For example, ( ).

The problem is that the space is 0xA0 NO-BREAK SPACE, not an ordinary space. The underlying code point can be seen in Calc by clicking in the input line after the space and then pressing Alt+x. Requires a recent version, maybe LO 5.1 or higher.

To fix it, this problem, copy the non-breaking space from the original text in Calc and then paste it into the SUBSTITUTE expression.

Attached sample file.ods

Alternatively, edit the original text and change the non-breaking space to an ordinary space. You might want to use Find & Replace to fix all occurrences.

Note: I could not find a way to display a literal non-breaking space on this wiki. It gets converted to 0x20, an ordinary space. For example, ( ).