texto to column by formula

[doriannjeshi]

Hi,

trying to trim this to the second delimiter by using a formula

111-11-1
result
111-11

exp2
ddd-dd-1
result
ddd-dd

 

[doriannjeshi]

Spreadsheet ,

first thank you for responding

I need to understand sth:

1. Where do I change the sumif formula to adapt it to diferent scenarios
2. I want the macro to include a copy and paste part so I can turn the formulas into values

 

[doriannjeshi]

Ok I figured it out how to change the formula

I need to add the copy and paste action to the macro !

 

[sheetspread]

In the example I provided:

Range("F2:F" & lre).value = Range("F2:F" & lre).value

will convert the formulas to values.