Excel, Right formula

Question

I am trying to use a formula like this: =right(F6,6). The format is set to "general". When I enter the formula, all that shows up is a blank cell with no result, when I click back into that cell the calculation appears in the fx box at the top. I am wondering how to get the formula to calculate when format for the cell is set to general already?

Answer 1

... but maybe you have more than six trailing spaces in the value in Cell F6 .. 

@todtown,

Good point!

I am trying to use a formula like this: =right(F6,6) ...

@R888, 

If the above assumption is correct you should be able to quickly trim an entire column of text entries (likely imported) by selecting the column and clicking the Data tab's Text to Columns command. Once the Text to Columns Wizard opens up, select Fixed Width then click Finish.

Answer 2

the formula shows rabbit

Then it is working.  'rabbit' in F6 is 6 letters, and so a formula of

=right(F6,6)

would show all 6 characters.

Try   rabbit ears  in F6, it should show up in the cell with the formula as 't ears'.

For words shorter than 6 characters in F6, it will show the entire word.

Answer 3

Hi,

Check for the following:

1. The font colour off the cell should not be white
2. There should be no conditional formatting in the cell which turns the font colour to white

Answer 4

the formula shows rabbit

Answer 5

Type the word rabbit in F6; what does the formula show?