How to delete specific content of column

Help Studio
,
1

Special.xlsx (43.7 KB)

image
image1440×900 112 KB

Hello All,
I want to delete Data of cells of B Column except for “Description” which is present in a few cells of column B. Please Provide me solution for this issue. I have attached excel file for same

2

Hello @Ripusudan_Sharma,

Might you clarify what do you need to delete? Do you want to delete “Description”?

Thanks :slight_smile:

4

I want to keep “Description” and delete all other values

5

@Ripusudan_Sharma - Have you tried Delete Range with Range as “B6:B100” something like this…this will leave you Description

6

If you look at attached excel file, it has description as header at particular interval, So need to make sure it is not deleted.

7

@Ripusudan_Sharma – Let us know, what you have tried so far? BTW: I understood your query…

8

I tried filterData table, but it is not working

9

How about using For each row,
if row.item(“ISIN”).ToString is not Empty, Assign row.item(“Description”) = “”