Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default replace one tag in content of one cell and format not changed

You have a reply at your other post.

replace one tag in content of one cell a wrote:

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


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format changed when the details in cell changed angel Excel Worksheet Functions 9 July 15th 08 12:36 AM
replace the content of cell Wu Excel Discussion (Misc queries) 3 December 11th 07 12:13 PM
run macro automatically when cell content is changed? Kathrine Excel Worksheet Functions 1 March 22nd 07 10:44 PM
Can Comment in a cell be changed as the content in another cell ?? Amit Kumar Baidyaka Excel Discussion (Misc queries) 3 January 10th 07 03:35 AM
replace one tag in content of one cell and format not changed replace one tag in content of one cell a Excel Discussion (Misc queries) 1 January 9th 06 03:36 PM


All times are GMT +1. The time now is 01:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"