I have cell A and cell B
in Cell A I have string of text example: "Men's T-shirt (Small Black)"
Cell B says "Yes"
I want formula to do: if Cell B says YES, in cell A remove brackets and everything inside brackets leaving only rest of the text, how can I do this.
Thank you so much!
I suspect that your data is more complicated than your sample. Post a file...
You would have to put the results in a third column or use a macro since a cell can have either data or formulas not both.
c1:
Please Login or Register to view this content.
Last edited by protonLeah; 02-02-2023 at 12:15 AM.
Ben Van Johnson
Thanks for your reply. Cell A looks like this:
=E7 & " ("&T7 &" " & V7 & ")"
I want to delete this part & " ("&T7 &" " & V7 & ")" if cell B says YES, so basically (Small Black) will be removed.
formula should leave only =E7
something like IF B1 is YES, Cell A equals E7 otherwise, leave as is.
Last edited by paata01; 02-02-2023 at 10:36 AM.
as requested... pleas epost a sample excel file. see yellow banner (top) for guidelines.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Please check attachment. So what I am trying to do is, if column E has YES, column A to show only =B2 otherwise leave as is
You cannot change A without using VBA
in separate cell e,g C1:
=IF(B1="YES",TRIM(LEFT(A1,FIND("(",A1)-1)),A1)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
hm, I think it should be possible as all values are linked to other cells, something like if YES =B2, otherwise =B2 & " ("&C2 &" " & D2 & ")"
try
Formula:
Please Login or Register to view this content.
MaybeFormula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks