Pull Text Before and After Colon?

[EnigmaMatter]

Hello,

I have a list of varying strings:

ItemParent1:ItemName1
ItemParent2:ItemName2

How would I write a formula to pull ItemName1 only? Essentially, how do I pull the text after the colon?

What if I wanted to ItemParent1? Essentially, how do I pull the text before the colon?

[Fotis1991]

Hello

Try.

Please Login or Register  to view this content.

[EnigmaMatter]

Hey, it worked great! I ended up doing a little research and found the exact formula on the internet. However, simply replacing RIGHT with LEFT did not work for me...I had to use:

Please Login or Register  to view this content.

I am not sure how that worked exactly, but it did.

[AlKey]

As an alternative you can also use this one in B1

=TRIM(RIGHT(SUBSTITUTE(A1,":",REPT(" ",25)),25))

Row\Col	A	B
1	ItemParent1:ItemName1	ItemName1
2	ItemParent2:ItemName2	ItemName2