CONCATENATE function giving a VALUE error EXCEL 2013

0 votes
Since Excel 2013 doesn't yet support the =CONCAT() fn, I was experimenting with the =CONCATENATE() fn instead. It worked perfectly when I added a "," between the two cells. However, it gave the #VALUE error when I attempted to input it as a range (=CONCATENATE(A1:B1)). Any suggestions on how I might approach this problem?
Nov 12 in Others by Kithuzzz
• 20,660 points
28 views

1 answer to this question.

0 votes

You can use the following:

=A1&","&B1

TEXTJOIN would also be helpful, but unfortunately not available in 2013.

answered Nov 12 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

ActiveWorkbook.SaveAs excel 2013 1004 error

Error reproduction: I was able to reproduce the ...READ MORE

answered Sep 25 in Others by narikkadan
• 37,660 points
38 views
0 votes
1 answer

Excel OFFSET function with a dynamic row argument

The answer is to make "anchor cells" ...READ MORE

answered Sep 26 in Others by narikkadan
• 37,660 points
77 views
0 votes
1 answer

Is there a function to unhide columns in excel through python

Excel file : df.to_excel('demofile.xlsx',index=False) import openpyxl py = openpyxl.load_workbook('demofile.xlsx') exlsheet = ...READ MORE

answered Oct 18 in Others by narikkadan
• 37,660 points
75 views
0 votes
1 answer

Is there a coalesce-like function in Excel?

To have Excel analyze the formula as ...READ MORE

answered Oct 21 in Others by narikkadan
• 37,660 points
107 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE

answered Oct 7 in Others by narikkadan
• 37,660 points
89 views
0 votes
1 answer

How do you calculate the Quintile for groups of rows in Excel?

Use this formula: =MAX(1,ROUNDUP(10*PERCENTRANK($C:$C,$C2,4),0)) To divide into whichever many ...READ MORE

answered Oct 17 in Others by narikkadan
• 37,660 points
37 views
0 votes
1 answer

Camel case converter in an excel

Try this: =LOWER(LEFT(A1)) & MID(SUBSTITUTE(PROPER(A1),"_","") ...READ MORE

answered Nov 19 in Others by narikkadan
• 37,660 points
28 views
0 votes
1 answer

Microsoft Excel: Formula bar says "Calculations!" instead of the equation used

By right-clicking the Retirement Planner sheet tab ...READ MORE

answered Nov 26 in Others by narikkadan
• 37,660 points
17 views
0 votes
1 answer

How to get rid of a #value error in Excel?

Changing the format to "Number" doesn't actually ...READ MORE

answered Oct 3 in Others by narikkadan
• 37,660 points
81 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP