Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mass Changes in Excel using Wild Cards or other
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mass Changes in Excel using Wild Cards or other
Let's say that cell A1 contains:
abcdDByy1234 where the yy is arbitrary. In another cell enter: =MID(A1,1,FIND("DB",A1)+3) & "X" & RIGHT(A1,LEN(A1)-FIND("DB",A1)-3) which will display: abcdDByyX1234 You can perform the same type of process in-place with VBA. -- Gary''s Student - gsnu200789 "Rev Les Hall" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wild Cards with IF stmt | Excel Worksheet Functions | |||
wild cards? | Excel Discussion (Misc queries) | |||
wild cards in SUMIF | Excel Worksheet Functions | |||
If Statement Using Wild Cards | Excel Worksheet Functions | |||
Wild Cards With Arrays | Excel Discussion (Misc queries) |