[Solved] How to copy a non-blank cell to another cell

[needsleep]

I have Column T with either numbers, characters, or no entry.
I have Column E in which I would like to use a formula to copy what's in Col T.

=IF(NOT(ISBLANK(T7)),T7,"")
shows TRUE or FALSE.

How do I get the value itself copied over?
Will "" above enter a null into the cell in Col E?

Thanks,

[FJCC]

Check the cell format in the menu Format -> Cells -> Numbers Tab. Is the Category set to Boolean?

Will "" above enter a null into the cell in Col E?

The "" is an empty string. The cell will not be blank, if that is what you mean by a null.

[Zizi64]

The formula

Code: Select all

=IF(NOT(ISBLANK(T7));T7;"")

works fine for me in the AOO 4.1.5 portable.
Use the regular semicolon ; separator character instead of the comma. (The comma is the decimal separator in many languages.)

[Zizi64]

shows TRUE or FALSE.

Maybe the result cell is formatted as "Boolean". The zero numeric value (like the strings and the empty cell will give the result "false", and the non zero values will give the result "true".

[needsleep]

Formatting was NUMBER. I changed it to TEXT, and changed the formula to use semi-colons and now it works perfectly.
Thank you both, @FJCC, @Zizi64.

[Lupp]

Sorry. This won't work in the long run.

As soon as you edit the formuala in a cell having applied the 'Numbers' format 'Texct' (@ as code), the edited formula will itself be interpreted as the text content of the cell. No calculation, no result returned.

To switch off a wrongly applied "automatic format" better copy/paste the format of a not infected cell or go 2 steps:
-1- Select a special 'Numbers' format.
-2- Select the common 'Number' with code 'General' (or 'Standard' in some locales).

[needsleep]

And that too, is exactly what happened. Thanks for pointing me to the solution.