Jul 23 2019 07:34 AM
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
Jul 23 2019 09:16 AM
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
Jul 23 2019 11:42 AM
Jul 23 2019 12:02 PM
=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...