Reevaluate Cells in Excel

gambit023

New Member
Joined
Jul 14, 2009
Messages
29
Can anyone tell me how to reevaluate cells in Excel? For example, I have a concatenate function in column B to add a value of "Cancel" at the bottom of the list from column A.

However, it looks like it keeps all values (visually) on one row in Excel. How do I make it look like what's in cell C1?

Thank you in advance.

open



ABC
1New Order
Refill
New OrderRefillCancelNew Order
Refill
Cancel
2New Order
Refill
New OrderRefillCancelNew OrderRefillCancel
3New Order
Refill
New OrderRefillCancelNew OrderRefillCancel

<tbody>
</tbody>
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
I'm not sure how they have split column A into 2 lines .... but if you concatenate "CHR(10)" (without quotes) between your source and the text you add then "Cancel" should appear on a separate line.
 
Upvote 0
My function in B1 is this: =CONCATENATE(RC[-1],CHAR(10),"Cancel")

It looks like the carriage returns are actually in the cell, but it just does not visually format like so. I copied the values only without the function into column C; that too won't visually format until I double click into a cell in column C and then press Enter.
 
Upvote 0
I think I found the solution. I highlight the entire column, right-click and format cells > Alignment tab > check on Word Wrap.
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,974
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top