Microsoft Office excel 2007 home & stude...

Can within the same column, only the first number in a series of numbers be changed without changing the others numbers that are the same. Example:

9277468763 to H277468763

9277554349 to H277554349

9978454359 to H978454359

If you actually want it done within the column itself, you'll need a macro. If you are willing to perform a couple of extra steps then you can accomplish the same thing with a single formula and a couple of Editing commands.

I'll assume your numbers start in A1...adjust my suggested formula as required:

In Row 1 of some other column, enter this formula and drag it down:

="H"&RIGHT(A1,LEN(A1)-1)

Now select the new values and do an Edit...Copy (CTRL - C)

Select the first cell of the original values and do an Edit...PasteSpecial...Values

Finally, delete the values created by the formula.

Ask Your Question

Weekly Poll

Did you buy anything on Amazon's Prime Day?

Discuss in The Lounge

Poll History