Prev: How to reference a spacific cell in multiple saved excel files.
Next: gridlines in pivot table
From: Gazz_85 on 4 Mar 2010 08:49
I have over 400 entries in a colomn which start with 0015...and then more
numbers.

how can easily edit on mass so that they now begin with only 015 ???

cheers
From: Mike H on 4 Mar 2010 08:58
Hi,

To get these leading zeroes there are 2 likely possibilities:-

1. The cells are formatted to show them so simply alter the format.

or

2. The numbers are really text and I have assumed this is the case.

So if the 'numbers' start in a1 put this in b1 and drag down

=RIGHT(A1,LEN(A1)-1)

Copy this new range and then select the 'old' range and
Edit|Paste special - select values - OK
delete the column with the formula in.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Gazz_85" wrote:

> I have over 400 entries in a colomn which start with 0015...and then more
> numbers.
>
> how can easily edit on mass so that they now begin with only 015 ???
>
> cheers
From: Bob I on 4 Mar 2010 09:06
If there are no other instances of "00" you could use Find, Replace
"00", "0"

Gazz_85 wrote:
> I have over 400 entries in a colomn which start with 0015...and then more
> numbers.
>
> how can easily edit on mass so that they now begin with only 015 ???
>
> cheers

 | 
Pages: 1
Prev: How to reference a spacific cell in multiple saved excel files.
Next: gridlines in pivot table