Hello,
please help as you can automatically insert a character in selected cells between the data already entered in the cell. I have about 5,000 lines, and for each line I want to put a "/" in the space between the second and third letters or a digit (character) from the right. It would look like this:
abcd1234 -> adcd12 / 34
cdefghijk -> cdefghi / jk
The "/" sign should always be inserted in the same place (i.e. between the 2nd and 3rd characters from the right)
How can this be solved in Excel (2003 or 2007)?
Can you do something like this automatically at all?
please help as you can automatically insert a character in selected cells between the data already entered in the cell. I have about 5,000 lines, and for each line I want to put a "/" in the space between the second and third letters or a digit (character) from the right. It would look like this:
abcd1234 -> adcd12 / 34
cdefghijk -> cdefghi / jk
The "/" sign should always be inserted in the same place (i.e. between the 2nd and 3rd characters from the right)
How can this be solved in Excel (2003 or 2007)?
Can you do something like this automatically at all?
