CONCATENATE function

[New_B]

I have 200 rows. B2 has a value of 120, B3 has a value of 121 and so on.

I am using CONCATENATE function as below but it is showing value of 0.

=CONCATENATE("60.200.121.",B2)

60.200.121.120 

[#2]

Hello @New_B,

Your formula checks out for me so I'm not sure why it is returning 0 for you. Give this formula a try instead:

="60.200.121."&B2

Hope this helps!
PReagan

[#3]

@PReagan 

It did not work.

[#4]

In the function bar, highlight your entire function and press F9. Does it return your desired result? If so there may be a formatting issue that causes your function to return 0.

[#5]

=CONCATENATE("65.205.231.",120)

I get 65.205.231.120  <-- No issues

But when I use

=CONCATENATE("65.205.231.",B2)

I get 0 <-- Issue

Note: B2 is 120, B3 is 121, B4 is 121 etc...