i need help in xecel please help.?

Question

i want to convert a value in one column that is "03333392503" to the value "923333392503". how can i convert it. please help and tell me the formula to convert it. pleae help

Answer 1

If the original value is in cell A1, then
="92"&RIGHT(A1,LEN(A1-1))

Let me explain the function
The RIGHT function takes the right set of letters from the string specified. It will take the number of letters that are state.
The LEN function states how many letters are in the string.
The & operator concatenates the two strings together (you could also use the CONCATENATE function).

This function thus take the "92" and puts it on the front of the string, then adds the letters from the original string except for the left most letter.

Answer 2

Well I cant believe this is the answer.
=a1+920000000000

Or if the number is a text field
=concatenate("92",a1)
or if you have a leading zero
=concatenate("92",right(A1,10))

Is that really all you wanted to know?

Answer 3

try this in adjacent column with some function that eliminate the starting character, i.e. o from the original number

=CONCATENATE(92, A1)

Answer 4

Your question is so incredibly vague that I couldn't begin to attempt to answer this. Would you mind including some more details?

I don't see why you can't just retype the value where you need it changed.

Answer 5

Assuming the number is at cell A1; then use the following:
=CONCATENATE(MID(A1;6;2);A1)

You can use for any number with same number of digits.

regards,
:)