Posted to microsoft.public.excel.programming

Stuart[_3_] Stuart[_3_] is offline

external usenet poster

Posts: 50

Macro to add the " symbol to the beginning and end of cells selected

Dear All

I hope someone can assist.

I am trying to add the " symbol to the beginning and end of my cell
values.

I have dates in some of the columns so I do not want any of the
formatting changed.

For example in cell A1 I have apple. I would like this to read
"apple" or in cell B1 I have the date 29-Feb-2008. I would like this
to read "29-Feb-2008"

Hope you help and thanks in advance,

Stuart

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
search for text "beginning with" "containing" wildcards	David H	Excel Worksheet Functions	1	January 13th 10 01:24 PM
in Excel: How do I change "selected cells" highlight color?	flameretired	New Users to Excel	5	June 24th 09 08:39 PM
create macro "merge selected cells"?	Mamoudou	Excel Programming	7	December 22nd 07 10:57 PM
Create a "cell button" to hide selected cells.	Shoolin Patel	Excel Worksheet Functions	12	July 30th 07 11:00 AM
Macro to take selected cells times a selected cell	Craig	Excel Programming	4	October 24th 05 12:54 AM

All times are GMT +1. The time now is 11:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us