' character in excel

  • Thread starter Thread starter holhol1214
  • Start date Start date
H

holhol1214

In older versions of excel the ' character could be used as the first
character in a cell to mke the following character repeat itself throughout
the cell. This command no loner works. What command was used to replace it?
 
You sure that the character wasn't a backslash (\) with:
tools|options|transition tab|transition navigation keys
checked.

You could try:
type the character(s) in the cell.
Format|cells|alignment tab|Horizontal Text Alignment box|Fill
 
Type the character you want then
Format|Cells|Alignment tab|Horizontal text alignment|Fill

or
Format|Cells -> Number -> Custom
*A
Repeates A

or
=REPT("A",300)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Replace weird character 2
find -> list of records 2
Excel Help creating Excel formula 1
"Centre Across Selection" and character limit 1
Formula to validate characters within a string of data in aparticular cell 1
How do I repeat characters within a single cell in Excel? 3
How do I get more than 255 characters into a cell? 3

Back
Top