Copy some part of content to another cell based on condition

[itsnexgen]

Hello Friends,

I am stuck with some problem.

I want to copy some part of cell to another cell with condition.

in one cell i have

ABC,XYZ
QWE
RTY,RTC

now what i want is here :

XYZ
RTC

should be copied to another cell since its after ","

Can you please help?


Thanks and rgds,
KINO

[oldchippy]

Hi,

You can use Data > Text to Columns and use the comma as the separator in Step 2

[NBVC]

something like:

=IF(ISNUMBER(SEARCH(",XYZ",A1)),"XYZ")

[itsnexgen]

thx bro.. text to columns worked!

u beauty.. perfect!! Thanks a lot! big head ache gone..!

Thanks to all helping me!