View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
replace one tag in content of one cell a
 
Posts: n/a
Default replace one tag in content of one cell and format not changed

replace one tag in content of one cell and format not changed
I want to replace one tag '#abc#':
for example, the content of cell is: 123#abc#456
the format of '123' is Bold
the color of '456' is red
After replaced these formats of words don't be changed
How can I do?
VBScript?
Now if I use the function of replace, only one format is left