Concatenate Issue

ssblue
ssblue used Ask the Experts™
on
Excel - Concatenate issue.
Please see attachment.
I need to know why this is not working and how do I fix it.
concatenate.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Ctrl+1 in cell and change numeric format from Text to General.  Select cell and with cursor in formula bar, press F2 to recalculate.
ssblueCoordinator

Author

Commented:
Thanks!
Roy CoxGroup Finance Manager

Commented:
Your file data looks corrupted to me. I transferred the data to a new workbook and it works fine. I also tested CONCAT and TEXTJOIN. TEXTJOIN requires OFFICE 365.

In your workbook all the data is preceded by ', I tried deleting them and replacing using Find & Replace but could not remove them. Copying to a new workbook worked for me.
EE-Concatenate.xlsx
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
The formula didn't work because the column K is formatted as Text. To make it work, select whole column K and change number format to the General (as suggested by khobson) and then select cell K2, press F2 and hit Enter, the formula will calculate correctly. Then you can copy the formula down.
concatenate.xlsx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial