Forum Discussion

MarkT2551's avatar
MarkT2551
Copper Contributor
Jun 16, 2023

How to Combine Two columns into One

Column A begin ConfiguredSIPBinding ConfiguredSIPBinding. FaultMonitoringProfile FaultMonitoringProfile.1 ApplyFMPToRelatedObjectTypes {Subscriber SIP T...
excel
MarkT2551's avatar
MarkT2551
Copper Contributor
Jun 16, 2023
Yes Sir- Perfect!
Thank you very much!
  • MarkT2551's avatar
    MarkT2551
    Copper Contributor
    Jun 16, 2023
    Last question on this- If I need to change the data in column A to this...
    begin ConfiguredSIPBinding ConfiguredSIPBinding.
    FaultMonitoringProfile None
    end

    How would the formula look with the new information? I tried looking at what defined column A in your first response. It looks like it's part of a =template but I couldn't figure out how to edit the template or I was heading down the wrong path.
    • MarkT2551's avatar
      MarkT2551
      Copper Contributor
      Jun 16, 2023
      NM- I lucked up and found how to edit the cells for the "template" - Thanks Again
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Jun 17, 2023

        MarkT2551 

        Yes, "template" is just named range for A1:A5. You may change on any other one in Name Manager.

Resources