Reputation: 9

Excel Cell Lookup

I need to return word after "-" for each cell.

software - agent

software - java

application - java

infrastructure - number

I want to be able to write a formula that will return:

agent

java

number

Is there a formula for it? There are more possibility of word to be return so it is not just "agent", "java", and "number".

Upvotes: 0

Answers (2)

Reputation:

In cell B1, enter the formula:

=RIGHT(A1,LEN(A1)-SEARCH("-",A1))

and copy and paste cell B1 for the required number of rows in column B.

Upvotes: 3

Reputation: 11

You can use the Text to Columns and use the (-) character as your Delimited character to separate the columns.

Upvotes: 1