Hi I have a cell which is multi-line i need to get text after specific prefix
Primary Examiner: STNFORD, CHRITOPHER J
i only wish to extract BOLD text from entire cell. this prefix can be repeated many time then output need to be stacked in same cell.
attached is the sample file with desired VBA output.
can anyone help with VBA
regards
Monika
Last edited by chilli16; 05-29-2018 at 04:52 AM.
Do you need it to be VBA?
yes it is more suitable for my need
Can you attach a greater sample of the data? One sample is not big enough.
Guess:
Please Login or Register to view this content.
thank you @ikboy it worked like a charm, can you help me with macro instead of Function my boss will make mistake in running same.
=GetData(RC[-4],"Examiner:")
Please Login or Register to view this content.
Please Login or Register to view this content.
Thank you jindon
@Jindon
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Please Login or Register to view this content.
You are welcome.Originally Posted by chilli16
Remember we always expect the feed back from the OP, otherwise we never know it the suggestion worked or not.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks