software

Hi,

I am no wizard when it comes to excel so any help would be great.

How do you insert quot; before and after each sentence in every cell?

I have 4200 cells with text that needs to have quot; before and after each
sentence.--
zooloo
------------------------------------------------------------------------
zooloo's Profile: www.excelforum.com/member.php...oamp;userid=30312
View this thread: www.excelforum.com/showthread...hreadid=499780Zooloo,

Assuming your cells are in column A, and handling A1 for this example:
In B1 put =quot;quot;quot;quot; amp; A1 amp; quot;quot;quot;quot;
Then copy and paste values from B to where ever you want the results.

By the way, that's four quotes before and after.

Art

quot;zoolooquot; wrote:

gt;
gt; Hi,
gt;
gt; I am no wizard when it comes to excel so any help would be great.
gt;
gt; How do you insert quot; before and after each sentence in every cell?
gt;
gt; I have 4200 cells with text that needs to have quot; before and after each
gt; sentence.
gt;
gt;
gt; --
gt; zooloo
gt; ------------------------------------------------------------------------
gt; zooloo's Profile: www.excelforum.com/member.php...oamp;userid=30312
gt; View this thread: www.excelforum.com/showthread...hreadid=499780
gt;
gt;


Thanks Art it works perfect!--
zooloo
------------------------------------------------------------------------
zooloo's Profile: www.excelforum.com/member.php...oamp;userid=30312
View this thread: www.excelforum.com/showthread...hreadid=499780