updating three columns

[dankar]

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[/TR]
[TR]
[TD]E1
[/TD]
[TD]E1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E1
[/TD]
[TD][/TD]
[TD]E1
[/TD]
[/TR]
[TR]
[TD]E1
[/TD]
[TD]E1
[/TD]
[TD]E1
[/TD]
[/TR]
[TR]
[TD]E3
[/TD]
[TD]E3
[/TD]
[TD]E3
[/TD]
[/TR]
[TR]
[TD]E5
[/TD]
[TD]E5
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E6
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Table name : Acronym
I have a table with thousand of acronym.

I need to update the three columns to the new format (E-1,E-3,E-5,E-6)

how can I update the table..Thank you

 

[Joe4]

There are a few ways of doing this.

One way is to try using the Find/Replace functionality on the table level.
Another way it to use an Update Query. See: https://support.office.com/en-us/ar...te-query-9dddc97c-f17d-43f4-a729-35e5ee1e0514