CODEWITHSUNDEEP
excelexcel-formula
abu abu
abu abu

Reputation: 7028

Replace part of columns string value

I have a column with values like /i/t/item_xxl_12063874_18123233.jpg. I need a formula to get a string value item_xxl_12063874_18123233.jpg.

Upvotes: 0

Views: 47

Answers (2)

Solar Mike
Solar Mike

Reputation: 8375

Another approach is to find the text "item" as follows:

=MID(A1,FIND("item",A1,1),LEN(A1))

you can change the text you search for as necessary and it does not matter how many are before the text you search for as long as it only occurs once.

Upvotes: 0

A.S.H
A.S.H

Reputation: 29332

If it's always to remove the first 5 characters, simply

=MID(A1, 6, 9999)

BUT if it is about retrieving what is after the last /, with a random amount of characters before it, then it is a little more tricky:

 =TRIM(RIGHT(SUBSTITUTE(A1, "/", REPT(" ", 300)), 300))

Upvotes: 1

Related Questions