Thread
:
Mass Changes in Excel using Wild Cards or other
View Single Post
#
3
Posted to microsoft.public.excel.misc
Peo Sjoblom
external usenet poster
Posts: 3,268
Mass Changes in Excel using Wild Cards or other
I suspect the OP has more characters in the cell or else he wouldn't try to
use
wildcards.
AFAIK
there is no built way in Excel to do this, I am sure it is
possible
in Word but in Excel one would need VBA
--
Regards,
Peo Sjoblom
"Arvi Laanemets" wrote in message
...
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
Peo Sjoblom
View Public Profile
Find all posts by Peo Sjoblom