Hi all,
wanted to ask you to help me with following thing:

Say I have a list of the numbers listed below. Now I need to add in front of every number "82", but only where the number in the cell does not begin with "82".

I have tried following:
I have added new column (B) in front of the one (C) with the numbers listed below. Then I have set the filter onto the column (C) with numbers with following rules:
- does not begin with 82 and
- does not equal empty

Then within newly added column (B) I have added formula: =82&cell reference which results into example: 820232166011
OK so far, but now I don't know how to transfer new numbers back into original column (C). How to replace existing 0232166011 with 820232166011? How should I do it if in the column with original numbers is set the filter?

Shouldn't be better to use some macro or VB?

Hope you can understand. In my spreadsheet I can have like 4000 rows.

8227108411
8227108410
0232166011
7108412
8225423375

027362002
0326808167
0236778905
8225072702
5406340


453646
23
777888999
11111
3432
0313694037
027350911
23432
8227108410
123
34543
8888

Thanks LT