Reply to thread

Message: [QUOTE="Ron Rosenfeld, post: 7416053"] You need to use VBA to do that. One way is with a worksheet selection_change event code. To enter this event-triggered Macro, right click on the sheet tab. Select "View Code" from the right-click drop-down menu. Then paste the code below into the window that opens. ==================================== Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, [a1]) Is Nothing Then If [b1].Text = "" Then [b1].Formula = "=IF(A1="""","""",A1)" Else [b1].Value = [b1].Value End If End If End Sub =============================== [/QUOTE]