| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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!!!
|
|
#2
|
|||
|
|||
|
Quote:
Are all of the values you need to alter 3AAA3 and all should end up 3AAA03? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add the same character(s) to multiple cells in a column (or row) . | Excel Discussion (Misc queries) | |||
| Test if Last Character in Column of Cells is Alpha Character | Excel Programming | |||
| Inserting same character into multiple cells--Macro? | Excel Discussion (Misc queries) | |||
| Insert a keyboard Character e.g (/)in multiple cells of a workshee | Excel Worksheet Functions | |||
| How can I insert a space before the last character in a range of cells | Excel Programming | |||
Hybrid Mode
