Need Specific Text in a Cell From a Cell which Have the Data

[abhishek_singhal]

Hi All

Need your help with writing a Macro to get some data. I have the data in an excel cell like:

ABC; PQR; XYZ; LMP - Reporting
BCD; GHI; JKL; DEF - Reporting

and so on. I want that complete text including that "- Reporting" after that ;. Final result should look like this:

ABC; PQR; XYZ; LMP - Reporting LMP - Reporting
BCD; GHI; JKL; DEF - Reporting DEF- Reporting


Thanks in advance for the help.

Abhishek

[mjr veverka]

1.

... I have the data in an excel cell like:
ABC; PQR; XYZ; LMP - Reporting
BCD; GHI; JKL; DEF - Reporting

???
Does it mean that way - see image: "Input Variants" ?
One line in one cell (Variant 1) or one line in many cells (Variant 2) ?

2.

... Final result should look like this:
ABC; PQR; XYZ; LMP - Reporting LMP - Reporting
BCD; GHI; JKL; DEF - Reporting DEF - Reporting

???
And analogously to the variants above - see image: "Input Variants" ?

[abhishek_singhal]

Hello

Thanks for the prompt reply. I think I made it little bit confusing, here is the screenshot for what is needed:

1.png

One point I forgot to mention earlier, that "- Reporting" can be anywhere in the complete text means it can be in the starting, middle or end. If that remains in the end all the time it would be easier to use Text to Column and use the last column.

[mjr veverka]

Does every line in column 'A' contain this text, i.e. '- Reporting' or can there be lines without this text ?

[abhishek_singhal]

Does every line in column 'A' contain this text, i.e. '- Reporting' or can there be lines without this text ?

Yes, all lines in column A will have that "- Reporting" text.

[mjr veverka]

Try:

Please Login or Register  to view this content.

[abhishek_singhal]

Hey

Thanks a lot, it worked perfectly. You are awesome...!