Removing specific characters from a string

[RachelBrown]

Hello,

I need to remove the first two, and the last five characters of a string, but the length of the string varies. Can someone help me get started?
The dataset has about 130,000 rows

Thanks!

 

[Marcílio_Lobão]

RachelBrown, Good evening.

Suppose:

A1 --> AA123456789012BBBBB

Try to use:

=LEFT(MID(A1,3,1000),LEN(MID(A1,3,1000))-5)

Is that what you want?

I hope it helps.

 

[jtakw]

Hi,

Or this:

Book1
	A	B	C
1	AA123456789012BBBBB		123456789012
2	JY234JK6789234K12980VNTUS		234JK6789234K12980
Sheet27

Cell Formulas
Range	Formula
C1	=MID(A1,3,LEN(A1)-7)

 

[Marcílio_Lobão]

jtakw, Good evening.

Very good approach!

Much better than mine. snif snif

Have a nice weekend.

 

[jtakw]

You're too modest Marcilio, mine's not necessarily better, just another way, we're all here to help, teach, and learn at the same time.
I've seen some Great postings from you.

 

[Marcílio_Lobão]

jtakw,

Thank you very much for the comments!

I learn a lot from all of you here.
Using logic to make these formulas in Excel is a hobby for me.

All the best for you and your family.

Greetings from Brazil !

 

[jtakw]

You're welcome, and Thank You also, Marcilio.
Excel is also a hobby for me, I've never even used Excel until I joined this forum.

Sorry Mods, not trying to make this thread into a Chat thread, but it's all good vibes.

 

[RachelBrown]

jtakw That is exactly what I needed.

Thank you both for the help!

 

[jtakw]

You're welcome, glad We were able to help.