Removing last 18 characters on Left side of excel Cell

[igmike]

In part of an ongoing larger project that a team member is helping me with, this will help me get one step closer, I've tried using =RIGHT(B3),LEN - N but due to the nature of the "Titles" in column B3 being different # of characters to the right, I thought there but be a more direct and simpler solution, to remove the last 18 characters on the left side of B3:B775. That is the one constant.

Your help is much appreciated.

Here are a few examples. (Excuse my lack of excel genie in this case)

[TABLE="width: 802"]
<tbody>[TR]
[TD]CALL of DUTY Black Ops Bundle 160GB 85+ 272826824787 5***v[/TD]
[/TR]
[TR]
[TD]CALL of DUTY Black Ops Bundle 160GB 85+ 272839937690 5***v[/TD]
[/TR]
[TR]
[TD]PS3 CALL of DUTY Black Ops Bundle 160GB 85+ 272888440351 5***v[/TD]
[/TR]
[TR]
[TD]Red Dead Redemption SPECIAL EDITION, PS3 90+ 201778548898 e***e[/TD]
[/TR]
</tbody>[/TABLE]

 

[JoeMo]

Your title is a bit confusing. Assuming you want to remove the last 18 characters. In C3 and copy down:

=LEFT(TRIM(B3),LEN(TRIM(B3))-18)

If you want to remove the left-most 18 characters try:

=MID(TRIM(B3),19,LEN(TRIM(B3)))

 

[igmike]

Your title is a bit confusing. Assuming you want to remove the last 18 characters. In C3 and copy down:

=LEFT(TRIM(B3),LEN(TRIM(B3))-18)

If you want to remove the left-most 18 characters try:

=MID(TRIM(B3),19,LEN(TRIM(B3)))

I see what you mean, it is a bit late, and I should have worded it more clearly. I will try the formula you have written as I believe it should do the trick.

To be precise, in the first example, here are the characters Id like to remove:

272826824787 5***v
272839937690 5***v
272888440351 5***v
201778548898 e***e

 

[igmike]

@JoeMo

The first formula executed perfectly. Thanks!

 

[jolivanes]

Makes perfect sense if you're ambidextrous Joe

 

[igmike]

well said @joli lol, at night I certainly qualify as ambidextrous, or computer drunk, as I rarely drink and code. haha. great board.