LinkBack URL
About LinkBacks
I have several cells that I want to join together, but also would love to have a comma in between each. Formula is showing correct results, but cell is just showing formula.
What am I doing wrong?
I have several cells that I want to join together, but also would love to have a comma in between each. Formula is showing correct results, but cell is just showing formula.
What am I doing wrong?
Delete the formula from the cell, set the cell to general format and then re-enter the formula. Does it now work?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
No need to delete the formula.Originally Posted by AliGW
Format the cell as General
Press function key F2 (or, use your mouse and double click on the cell)
Press Enter (or, click the Enter button)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I've not been able to fix it without deleting the formula when it has happened to me.No need to delete the formula.
Hmmm...
Odd, I use the steps in my other post and it works every time.
Re: Concatenate not working
That worked! I deleted the formula, changed to General, and re-entered the formula
Glad to have helped!
Thank you Ali!
Gracias Ali!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks