Format a column in Excel

Hi guys I need help formatting a column. I have column called Formatted ID. As it shows US525 DE323 and TS46. How can I filter it to where it only shows US and DE? If someone can upload an example I would be greatful.

Hai @kishanpatel728… Initially u need to use Excel Application Scope , Use read range to read entire sheet or specific range, then use for each row , then store Excel output as Data table, then use filter data table using “US and DE”

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.