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.
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,
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
>
>
Thanks Art it works perfect!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks