How do I add a return or tab or right arrow to the end of a formula?

[Charon_]

I have a formula that turns this 0011AA55BB44 into this 00:11:aa:55:bb:44
We use it to scan and enter Mac addresses.
What I need to do is add a "tab" or a "return" or a "right arrow" to the end of the formula so it will go to the next column (G2 in this case) after we scan something into the E2 column.

this is the formula from F2:
=LOWER(LEFT(E2,2)&":"&MID(E2,3,2)&":"&MID(E2,5,2)&":"&MID(E2,7,2)&":"&MID(E2,9,2)&":"&MID(E2,11,2))

I have tried the CHAR(10) or CHAR(28) but it will not work. I have tried it is word wrap on and off.

Please help.
Thanks

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[protonLeah]

A formula in a particular cell can READ values in other cells; however, they cannot jump to, or modify values in, any other cell. You will need a macro for that. So, you must provide much more info (a sample workbook always helps).

[Charon_]

Here is the workbook.
When we receive a shipment of computers we use a barcode scanner to scan the equipment into an excel sheet.
The Excel is set to move the selection right after pressing enter (under options) so after we scan something into field A2 it moves to B2 and so on.
The problem is that after we scan into C2 the selection moves to D2 (this means we have to stop scanning and press tab or right arrow on the keyboard)
We need the selection to move to E2 after scanning an entry into C2.
With E2 we need the selection to move to A3 after scanning.

[protonLeah]

I have unlocked columns A, B, C & E and added a macro that toggles sheet protection ON/OFF. With protection on, only columns A, B, C & E may be edited.

Option 2: Hide column D
Option 3: Write a keyboard macro such as Ctrl+n, instead of "Enter" that will only select one of the columns.

[Charon_]

That works.
Thank You.