ExcelBanter - Insert character to multiple cells

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Insert character to multiple cells (https://www.excelbanter.com/new-users-excel/448289-insert-character-multiple-cells.html)

LeahBea

Insert character to multiple cells

I am trying to find a function that will insert a character mid text to multiple cells. I need to make this "3AAA3" into this "3AAA03". I have tried the replace function and it does not seem to be working. Please help!!!

Ron Rosenfeld[_2_]

Insert character to multiple cells

On Thu, 28 Feb 2013 14:51:35 +0000, LeahBea wrote:

I am trying to find a function that will insert a character mid text to
multiple cells. I need to make this "3AAA3" into this "3AAA03". I have
tried the replace function and it does not seem to be working. Please
help!!!

You don't give much information as to the possible variety of data with which you will be dealing, but with
3AAA3 in A1, =REPLACE(A1,LEN(A1),0,"0") will result in 3AAA03

Spencer101

Quote:

Originally Posted by LeahBea (Post 1609900)

Are all of the values you need to alter 3AAA3 and all should end up 3AAA03?

All times are GMT +1. The time now is 02:30 AM.