troubleshooting Question

excel formula with conditions

Avatar of ITSupportLCBT
ITSupportLCBTFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft Excel
3 Comments1 Solution227 ViewsLast Modified:
I'm working on an excel spread sheet with three columns. Both column A and column B contain some data. Column C is empty. I need to populate column C based on the content of columns A and B. Specifically:

If  the string 'ABC' exits s anywhere in  the contents of cell A1, then I need the content of cell C1 to be whatever the content of B1 is but pre-fixed with 'UK-'.  If 'ABC' does not exist in A1, then C1 should remain blank.

For example if the content of A1 is 'test-ABC' and the content of  B1 is 'cat' then C1 should become 'UK-cat'.

What is the formula that will allow me to do this please?
NorieAnalyst Assistant
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros