Replacing only a specify location of a number

Microsoft Office excel 2007 home & stude...
July 27, 2010 at 14:04:17
Specs: Windows XP
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.


9277468763 to H277468763
9277554349 to H277554349
9978454359 to H978454359

See More: Replacing only a specify location of a number

Report •

July 27, 2010 at 15:14:53
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:


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.

Report •
Related Solutions

Ask Question