LinkBack URL
About LinkBacks
rituraj851 
Is this resolved?
Is this resolved?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hello AliGW,
Thank You very much for your response it is working absolutely fine. I have a small request if could you please help me understand the formula how it functions and if I want to make any changes like for e.g.: in Row 4 I want to extract these values in output required column. Basically the unique in every row.
LLC - Services, LLC - Digital, LLC Limited - (UK) - Services, LLC - Generation, LLC - Risk
Also another quick question is this formula specific to column B only? Suppose I have a similar data in column D and I need output in column E will it not work because when I copy paste the formula and change the range it is not working. The data is another cell is like
INSURANCE CO., LTD - VTS - VRM318491196 - 2023 - 2029340
Thanks,
Ritu Raj
Last edited by rituraj851; 10-11-2023 at 07:40 AM.
Hello Ali,
Thank You very much for your response it is working absolutely fine. I have a small request if could you please help me understand the formula how it functions and if I want to make any changes like for e.g.: in Row 4 I want to extract these values in output required column. Basically the unique in every row.
LLC - Services, LLC - Digital, LLC Limited - (UK) - Services, LLC - Generation, LLC - Risk
Also another quick question is this formula specific to column B only? Suppose I have a similar data in column D and I need output in column E will it not work because when I copy paste the formula and change the range it is not working. The data is another cell is like
INSURANCE CO., LTD - VTS - VRM318491196 - 2023 - 2029340
Thanks,
Ritu Raj
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks