Prev: Reminder - Microsoft Responds to the Evolution of Community
Next: Excel 2007 (Not Responding)
From: fazz on 20 May 2010 11:51
is it possible to highlight multiple cells and delete characters from the
beginning of them?
From: Eduardo on 20 May 2010 12:03
Hi,
do you have an example ?, if you want to delete let' say " you can do just
find and replace , find what ", replace with do not enter anything and clidk
on replace

"fazz" wrote:

> is it possible to highlight multiple cells and delete characters from the
> beginning of them?
From: tim m on 20 May 2010 12:04


"fazz" wrote:

> is it possible to highlight multiple cells and delete characters from the
> beginning of them?

Can you give an example of some of the data? Is the data all the same
length? Do you always just want to removed 1 character from the front or
does that vary? There are formulas you can use to accomplish this but what
formula you use depends on what your data is like.
From: Gord Dibben on 20 May 2010 12:09
If the characters are the same in all cells just edit>replace

One cell at a time use a helper column with LEFT or RIGHT fumctions.

e.g. =RIGHT(A3,LEN(A3)-2) will remove first 2 characters from A3

With VBA you can probably delete from all cells at once.

Is the data to be removed consistent?

Do you have any sample data you could post?


Gord Dibben MS Excel MVP

On Thu, 20 May 2010 08:51:01 -0700, fazz <fazz(a)discussions.microsoft.com>
wrote:

>is it possible to highlight multiple cells and delete characters from the
>beginning of them?

From: fazz on 20 May 2010 12:29
Hello Tim - what i really need to be able to do is remove blank spaces at the
beginning of a cell

"tim m" wrote:

>
>
> "fazz" wrote:
>
> > is it possible to highlight multiple cells and delete characters from the
> > beginning of them?
>
> Can you give an example of some of the data? Is the data all the same
> length? Do you always just want to removed 1 character from the front or
> does that vary? There are formulas you can use to accomplish this but what
> formula you use depends on what your data is like.
 |  Next  |  Last
Pages: 1 2
Prev: Reminder - Microsoft Responds to the Evolution of Community
Next: Excel 2007 (Not Responding)