CODEWITHSUNDEEP
excel
Badb0y
Badb0y

Reputation: 351

How can I mix two formula in excel?

How could I create from these two formulas only one?

C2 is the following in the first formula:

=LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(CSVimport.I2;" ";"-");"->";"/");"|";"/"))

2nd formula: =LEFT(C2;LEN(C2)-FIND("/";C2)+1)

Both formula should work on the csvimport.i2 just in one.

Or maybe there is an easier formula to achieve this: I want from this: 

Dell Latitude Laptop->Dell Latitude E5570 Laptop|Dell Latitude Laptop

to this only:

dell-latitude-laptop/dell-latitude-e5570-laptop/

With this 2 it works but would be good only one.

Upvotes: 0

Views: 33

Answers (2)

Scott Craner
Scott Craner

Reputation: 152495

Slightly shorter:

=LOWER(SUBSTITUTE(SUBSTITUTE(LEFT(CSVimport.I2;FIND("|";CSVimport.I2)-1);"->";"/");" ";"-") & "/")

![enter image description here

Upvotes: 0

user7259306
user7259306

Reputation:

I am not sure there is other way than this:

=LEFT(LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(CSVimport.I2;" ";"-");"->";"/");"|";"/"));LEN(LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(CSVimport.I2;" ";"-");"->";"/");"|";"/")))-FIND("/";LOWER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(CSVimport.I2;" ";"-");"->";"/");"|";"/")))+1)

Upvotes: 1

Related Questions