=CONCATENATE(A28,";",A29,";",A30,";",A31)
The above formula is intended to return product names that are composed of all numbers like this:
1234;12564;2154;1635486521;564
Any Idea why instead it just shows the formula instead?
THANK YOU!
=CONCATENATE(A28,";",A29,";",A30,";",A31)
The above formula is intended to return product names that are composed of all numbers like this:
1234;12564;2154;1635486521;564
Any Idea why instead it just shows the formula instead?
THANK YOU!
Is calculation set to automatic? ( see Tools Options)
Was the cell holding the formula pre-formatted as text?
I rebuilt it and it worked.... no idea
The auto calc was selected and the cell holding the formula was formatted as general number
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks