How do you get the single quote mark to show up in a cell" I am trying to
round Degrees-minutes-seconds to degrees-minutes. When I extract all the
components of the "Degree-minute-seconds" string (with the =mid function) out
into individual cells to do the rounding and then concatenate them back
together as "Degrees-minutes" the single quote (the minute mark) does not
show up in the cell by itself and therefore does not show up when
concatenated.

My temporary fix is just to place 2 single quotes in a cell instead of
extracting it with the =mid function, but I still want to know why it doesn't
work the other way and can I make it work, can you disable the logic that
associated the single quote with right justification?

=" ' " (remove the spaces - I've just putthem there so you can see what I did)


"STING" wrote:

How do you get the single quote mark to show up in a cell" I am trying to
round Degrees-minutes-seconds to degrees-minutes. When I extract all the
components of the "Degree-minute-seconds" string (with the =mid function) out
into individual cells to do the rounding and then concatenate them back
together as "Degrees-minutes" the single quote (the minute mark) does not
show up in the cell by itself and therefore does not show up when
concatenated.

My temporary fix is just to place 2 single quotes in a cell instead of
extracting it with the =mid function, but I still want to know why it doesn't
work the other way and can I make it work, can you disable the logic that
associated the single quote with right justification?

Have you tried the expression CHAR(39)? As in:

=MID(A2,4,2)&CHAR(39)&...

HTH
Kostis Vezerides

On Jun 19, 4:56 pm, STING wrote:
How do you get the single quote mark to show up in a cell" I am trying to
round Degrees-minutes-seconds to degrees-minutes. When I extract all the
components of the "Degree-minute-seconds" string (with the =mid function) out
into individual cells to do the rounding and then concatenate them back
together as "Degrees-minutes" the single quote (the minute mark) does not
show up in the cell by itself and therefore does not show up when
concatenated.

My temporary fix is just to place 2 single quotes in a cell instead of
extracting it with the =mid function, but I still want to know why it doesn't
work the other way and can I make it work, can you disable the logic that
associated the single quote with right justification?

=CHAR(39). Whooda thunkit! Thank you.

"vezerid" wrote:

Have you tried the expression CHAR(39)? As in:

=MID(A2,4,2)&CHAR(39)&...

HTH
Kostis Vezerides

On Jun 19, 4:56 pm, STING wrote:
How do you get the single quote mark to show up in a cell" I am trying to
round Degrees-minutes-seconds to degrees-minutes. When I extract all the
components of the "Degree-minute-seconds" string (with the =mid function) out
into individual cells to do the rounding and then concatenate them back
together as "Degrees-minutes" the single quote (the minute mark) does not
show up in the cell by itself and therefore does not show up when
concatenated.

My temporary fix is just to place 2 single quotes in a cell instead of
extracting it with the =mid function, but I still want to know why it doesn't
work the other way and can I make it work, can you disable the logic that
associated the single quote with right justification?