Write an Excel Function/Formula for an entire column of Excel

[NiranjanKN]

Hey guys,
I need to know how a excel function/formula can be used for an entire column of excel.

Like in this file Test.xlsx (9.0 KB) I’ve used a formula for AA2 row, which is to be used for that entire column.

Thanks

[shibani]

@NiranjanKN Hi,
use send hotkey and select, ctrl+space

[Palaniyappan (Palaniyappan P)]

did this thread help you resolve this

Fastest way to write an excel formula into an entire column

To put “” within a string, there are multiple options I read about on this forum. For me not all of them worked, so maybe try different ones. Say, you want to print the following text in a message box: welcome"guest" Options to put in your string: “Welcome”+”“”“+“Guest”+”“”" “Welcome”+”“”+“Guest”+“”" “Welcome”+ Chr$(34) +“Guest”+Chr$(34) Those are the options I found, for me only option 1 works

Cheers @NiranjanKN

[NiranjanKN]

In this file I don’t know the range of the rows.
I tried this

But, sometimes it just takes the column header name and pastes it to the entire column.

Thanks.

[NiranjanKN]

Hey guys,
Got a solution for it.
Test1.zip (15.2 KB)

Thanks