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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pma111Author Commented:
Weirdly though it works by replacing the comma with ,
0
pma111Author Commented:
|
0
pma111Author Commented:
Should have said works with a | instead of a ,
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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
Rory ArchibaldCommented:
It's nothing to do with which Excel version  you have.

It's your regional settings in the Control Panel in Windows.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pma111Author Commented:
Rory to the rescue! Thanks, sorted!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.