Thread
:
Mass Changes in Excel using Wild Cards or other
View Single Post
#
2
Posted to microsoft.public.excel.misc
Arvi Laanemets
external usenet poster
Posts: 510
Mass Changes in Excel using Wild Cards or other
Hi
EditReplace"replace: BD22" with: "BD22X"Replace AllOK
Arvi Laanemets
"Rev Les Hall" <Rev Les
wrote in message
...
Help - I've a large spread sheet that needs updating & I'd rather do it in
auto than have someone re-type each cell.
Is it possible to mass replace 4 Characters in a cell with the same 4
characters followed by another charcter or a space?
For example Replace BD22 with BD22X. I've tried the Wild Card ?? which
partially works in that by using BD?? it will find and replace BD?? with
BD??X but unfortunatelly the original charcters are then replaced by the
??
Thanks in anticipation
Reply With Quote
Arvi Laanemets
View Public Profile
Find all posts by Arvi Laanemets