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

Hi,

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

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

I have 4200 cells with text that needs to have " before and after each
sentence.


--
zooloo
------------------------------------------------------------------------
zooloo's Profile: http://www.excelforum.com/member.php...o&userid=30312
View this thread: http://www.excelforum.com/showthread...hreadid=499780

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

Zooloo,

Assuming your cells are in column A, and handling A1 for this example:
In B1 put ="""" & A1 & """"
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

"zooloo" wrote:


Hi,

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

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

I have 4200 cells with text that needs to have " before and after each
sentence.


--
zooloo
------------------------------------------------------------------------
zooloo's Profile: http://www.excelforum.com/member.php...o&userid=30312
View this thread: http://www.excelforum.com/showthread...hreadid=499780

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

Thanks Art it works perfect!


--
zooloo
------------------------------------------------------------------------
zooloo's Profile: http://www.excelforum.com/member.php...o&userid=30312
View this thread: http://www.excelforum.com/showthread...hreadid=499780