Find and delete text in a table

[Dave]

Hi all,

I have a table say 10 columns long by 5 columns high. There may be
text repeated sporadically throughout the table. As an example, if I
decide that row 1 is "negative" then I want each text field (10
columns) in row one and all the text fields like them thoughout the
table to be deleted. But, alas, I can't figure out how to do it.

Any ideas?

Thanks,

Dave

 

[Don Guillett]

Hi all,

I have a table say 10 columns long by 5 columns high. There may be
text repeated sporadically throughout the table. As an example, if I
decide that row 1 is "negative" then I want each text field (10
columns) in row one and all the text fields like them thoughout the
table to be deleted. But, alas, I can't figure out how to do it.

Any ideas?

Thanks,

Dave

Send your file with a complete explanation and before/after examples
to dguillett1 @gmail.com

 

[dave y.]

Hi all,

I have a table say 10 columns long by 5 columns high. There may be
text repeated sporadically throughout the table. As an example, if I
decide that row 1 is "negative" then I want each text field (10
columns) in row one and all the text fields like them thoughout the
table to be deleted. But, alas, I can't figure out how to do it.

Any ideas?

Thanks,

Dave

Can you use vba code to accomplish your task? If so, the replace
method will replace all instances of a string with a different value,
or you could just use looping to plow through the array cell by cell.

dave y.