Prev: Sumproduct Dynamic Range - XL2003
Next: Change scroll rows from 1 to 3 with mouse wheel
From: Paul on 5 May 2010 11:15
Hi guys, would appriciate your help with the following. I have an Excel sheet
where I copy information from Powerpoint presentations. When there is a
bullet in the powerpoint which I copy it is impossible to remove it from the
excel sheet. The bullet is not located in a particular field but 'floates'
(so to speak). It is not possible to click on the bullet or select it in any
other way. How do I remove the bullet?

Ps when I copy/paste to another Excel sheet the bullets are gone. However
this is not a solution since the file is huge and contains many macro's etc.
I promised my boss I would get rid of them so...

Thanks in advance for any help you can offer.

Paul
From: Bob I on 5 May 2010 11:30
Version 2007 has the Selection Pane (Under Find and Select) that you
could use.

Paul wrote:

> Hi guys, would appriciate your help with the following. I have an Excel sheet
> where I copy information from Powerpoint presentations. When there is a
> bullet in the powerpoint which I copy it is impossible to remove it from the
> excel sheet. The bullet is not located in a particular field but 'floates'
> (so to speak). It is not possible to click on the bullet or select it in any
> other way. How do I remove the bullet?
>
> Ps when I copy/paste to another Excel sheet the bullets are gone. However
> this is not a solution since the file is huge and contains many macro's etc.
> I promised my boss I would get rid of them so...
>
> Thanks in advance for any help you can offer.
>
> Paul

From: marysully on 5 May 2010 11:43
If it is possible, start again, highlight text in PP, then click off the
bullets by clicking on the bullet icon, then copy and paste into Excel.

"Paul" wrote:

> Hi guys, would appriciate your help with the following. I have an Excel sheet
> where I copy information from Powerpoint presentations. When there is a
> bullet in the powerpoint which I copy it is impossible to remove it from the
> excel sheet. The bullet is not located in a particular field but 'floates'
> (so to speak). It is not possible to click on the bullet or select it in any
> other way. How do I remove the bullet?
>
> Ps when I copy/paste to another Excel sheet the bullets are gone. However
> this is not a solution since the file is huge and contains many macro's etc.
> I promised my boss I would get rid of them so...
>
> Thanks in advance for any help you can offer.
>
> Paul
 | 
Pages: 1
Prev: Sumproduct Dynamic Range - XL2003
Next: Change scroll rows from 1 to 3 with mouse wheel