is there a way to overstrike characters in excel
 

Is there a way to combine or overstrike characters in excel?

Answer: is there a way to overstrike characters in excel
 

Yes, there is a way to overstrike or combine characters in Excel. Here are the steps:

1. Select the cell where you want to overstrike or combine characters.
2. Click on the "Home" tab in the Excel ribbon.
3. Click on the "Font" group.
4. Click on the small arrow in the bottom right corner of the "Font" group to open the "Font" dialog box.
5. In the "Font" dialog box, check the box next to "Strikethrough" to overstrike the characters.
6. To combine characters, click on the "Effects" tab in the "Font" dialog box.
7. Check the box next to "Overline" to add a line above the characters.
8. Check the box next to "Strikethrough" to add a line through the characters.
9. Click "OK" to apply the changes.

You can also use the keyboard shortcut "Ctrl + 5" to quickly add or remove strikethrough formatting. To add an overline or underline, you can use the keyboard shortcut "Ctrl + Shift + U" or "Ctrl + U", respectively.

Select the cell in question (or, within the cell, the text you wish to
strikethrough).

Select Format, Cells. Check the "Strikethrough" check box. Hit Okay.

Rgds

Rod

"Gary Rowe" wrote:

Is there a way to combine or overstrike characters in excel?

I don't mean "strikethrough". I mean to have a character typed on top of
another character so that they are combined into one. In MS word it's
referred to as overstriking.

"Rod Behr" wrote:

Select the cell in question (or, within the cell, the text you wish to
strikethrough).

Select Format, Cells. Check the "Strikethrough" check box. Hit Okay.

Rgds

Rod

"Gary Rowe" wrote:

Is there a way to combine or overstrike characters in excel?

Hi
AFAIK this is not possible in Excel

--
Regards
Frank Kabel
Frankfurt, Germany

Gary Rowe wrote:
I don't mean "strikethrough". I mean to have a character typed on
top of another character so that they are combined into one. In MS
word it's referred to as overstriking.

"Rod Behr" wrote:

Select the cell in question (or, within the cell, the text you wish
to strikethrough).

Select Format, Cells. Check the "Strikethrough" check box. Hit Okay.

Rgds

Rod

"Gary Rowe" wrote:

Is there a way to combine or overstrike characters in excel?

I don't mean "strikethrough". I mean to have a character typed on top of
another character so that they are combined into one. In MS word it's
referred to as overstriking.

It's not covered in MOS, it's not in Word Help, Googling suggests it can't
be done per se. Where did you hear it referred to as overstriking in Word?

Perhaps you're trying to combine 2 characters so the result looks like
something else. In a blank sheet,

=CHAR(ROW())

in A1 & copied down to A255 will show some special characters you can
access. Forex, use ALT+0216 for the character the above gets you in A216
(NB - type "0216" on the number keypad).

If this doesn't cover it, post more details.

Rgds,
Andy

The term 'Overstriking' dates from manual typing days, where you'd type,
backspace and type again. The only way I know to do it in Excel is to use two
textboxes, remove fill and line and type a different character in box. Use
Draw: 'Align or Distribute' to place the boxes on top of each other. Then
use Draw: 'Group' to tie the textboxes together.
Cumbersome, but if that's what you want....

"Gary Rowe" wrote:

I don't mean "strikethrough". I mean to have a character typed on top of
another character so that they are combined into one. In MS word it's
referred to as overstriking.

"Rod Behr" wrote:

Select the cell in question (or, within the cell, the text you wish to
strikethrough).

Select Format, Cells. Check the "Strikethrough" check box. Hit Okay.

Rgds

Rod

"Gary Rowe" wrote:

Is there a way to combine or overstrike characters in excel?

see KB article 193778 on using overstrike in MS Word

"Andy Brown" wrote:

I don't mean "strikethrough". I mean to have a character typed on top of
another character so that they are combined into one. In MS word it's
referred to as overstriking.

It's not covered in MOS, it's not in Word Help, Googling suggests it can't
be done per se. Where did you hear it referred to as overstriking in Word?

Perhaps you're trying to combine 2 characters so the result looks like
something else. In a blank sheet,

=CHAR(ROW())

in A1 & copied down to A255 will show some special characters you can
access. Forex, use ALT+0216 for the character the above gets you in A216
(NB - type "0216" on the number keypad).

If this doesn't cover it, post more details.

Rgds,
Andy