Excel Find and Replace Question - Microsoft Community

i have created workbook many sheets. text in half of cells contains "[space](new)", , want rid of of those.

i able find , replace (new), seem left space, making impossible access query lines.

can tell me how remove both space , (new)?

thank you!

i have uploaded macro-enabled version of workbook onedrive site.

revised macro cycle through sheets making appropriate deletions of space , text.

upload dropbox.xlsm

gord

Office / Excel / Windows 10 / Office 2016

Cororate