Home

CONCATENATE function

%3CLINGO-SUB%20id%3D%22lingo-sub-769812%22%20slang%3D%22en-US%22%3ECONCATENATE%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-769812%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20200%20rows.%20B2%20has%20a%20value%20of%20120%2C%20B3%20has%20a%20value%20of%20121%20and%20so%20on.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%26nbsp%3BCONCATENATE%20function%20as%20below%20but%20it%20is%20showing%20value%20of%200.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DCONCATENATE(%2260.200.121.%22%2CB2)%3C%2FP%3E%3CP%3E60.200.121.120%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-769812%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-770057%22%20slang%3D%22en-US%22%3ERe%3A%20CONCATENATE%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-770057%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F380771%22%20target%3D%22_blank%22%3E%40New_B%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20formula%20checks%20out%20for%20me%20so%20I'm%20not%20sure%20why%20it%20is%20returning%200%20for%20you.%20Give%20this%20formula%20a%20try%20instead%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%2260.200.121.%22%26amp%3BB2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps!%3CBR%20%2F%3EPReagan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-770244%22%20slang%3D%22en-US%22%3ERe%3A%20CONCATENATE%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-770244%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20did%20not%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-770279%22%20slang%3D%22en-US%22%3ERe%3A%20CONCATENATE%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-770279%22%20slang%3D%22en-US%22%3EIn%20the%20function%20bar%2C%20highlight%20your%20entire%20function%20and%20press%20F9.%20Does%20it%20return%20your%20desired%20result%3F%20If%20so%20there%20may%20be%20a%20formatting%20issue%20that%20causes%20your%20function%20to%20return%200.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-770336%22%20slang%3D%22en-US%22%3ERe%3A%20CONCATENATE%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-770336%22%20slang%3D%22en-US%22%3E%3CP%3E%3DCONCATENATE(%2265.205.231.%22%2C120)%3C%2FP%3E%3CP%3EI%20get%26nbsp%3B65.205.231.120%26nbsp%3B%20%26lt%3B--%20No%20issues%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20when%20I%20use%3C%2FP%3E%3CP%3E%3DCONCATENATE(%2265.205.231.%22%2CB2)%3C%2FP%3E%3CP%3EI%20get%200%20%26lt%3B--%20Issue%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%3A%20B2%20is%20120%2C%20B3%20is%20121%2C%20B4%20is%20121%20etc...%3C%2FP%3E%3C%2FLINGO-BODY%3E
New_B
New Contributor

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 

4 Replies

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

@PReagan 

 

It did not work.

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.

=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...

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies