formula you typed contains an erro

Excel 2010 reports an error for =concatenate("123","345") on my pc. Column is formatted general. Same formula works fine on other machines. Any idea how to resolve.
LVL 3
pma111Asked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
It's nothing to do with which Excel version  you have.

It's your regional settings in the Control Panel in Windows.
0
 
pma111Author Commented:
Weirdly though it works by replacing the comma with ,
0
 
pma111Author Commented:
|
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
pma111Author Commented:
Should have said works with a | instead of a ,
0
 
pma111Author Commented:
Ive also noticed when opening csv on some computers shows values with | between the cells and other computers show the , between the cells
0
 
meb_santosoCommented:
depends on your excel version, the separator was changed somewhere from a comma to a semicolon.

try =concatenate("123";"345")  (notice the usage of semicolon between 123 and 345).

See screenshot: (Excel 2010, Windows 7)
0
 
pma111Author Commented:
The semi colon produces the same error as the comma. This is 2010 on windows 7 but we have loads of computers with the same version and os and only mine seems to be affected
0
 
pma111Author Commented:
I was wondering if it was a setting in excel causing the issue
0
 
tomfarrarCommented:
What is the error, #VALUE!?
0
 
pma111Author Commented:
Rory to the rescue! Thanks, sorted!
0
All Courses

From novice to tech pro — start learning today.