adding a digit in a string, which formula to use?

**Lifeseeker** · 03-05-2012, 12:36 PM

Hi there,

I would like to a digit "2" after the 2nd string in a column of numbers.

which formula shall I use?

attached the file.

thanks

**Pepe Le Mokko** · 03-05-2012, 12:38 PM

Do you mean the number of occurrences of the string?

**Lifeseeker** · 03-05-2012, 12:41 PM

nvm solved it..

Please Login or Register  to view this content.

just adding 2 at a specified location

**daddylonglegs** · 03-05-2012, 12:44 PM

You could use REPLACE function, i.e.

=REPLACE(A1,3,1,2)

Re: adding a digit in a string, which formula to use?