do this in B Column but if C has value and is not empty do in C instead! please help

**paata01** · 06-15-2022, 05:34 PM

I dont know how to explain correctly ) so I have A, B and C columns in A column I am using this formula ="("&MID(B1,8,LEN(B1)-15)&")" it takes value from B removes first and last characters and puts () signs, how can I do modify this formula to look at C value also and if C is not empty take values from C but I dont want first and last characters removed like in formula, just add () signs.
Thanks!

**Sam Capricci** · 06-15-2022, 06:24 PM

is this what you are looking for?...
=IF(C1<>"","("&C1&")","("&MID(B1,8,LEN(B1)-15)&")")

**paata01** · 06-15-2022, 06:55 PM

yes! thank you so much really appreciate it.

**Sam Capricci** · 06-15-2022, 07:07 PM

You're welcome, AND thank you for the rep!

do this in B Column but if C has value and is not empty do in C instead! please help

LinkBack

Thread Tools

Rate This Thread

Display

do this in B Column but if C has value and is not empty do in C instead! please help

Re: do this in B Column but if C has value and is not empty do in C instead! please help

Re: do this in B Column but if C has value and is not empty do in C instead! please help

Re: do this in B Column but if C has value and is not empty do in C instead! please help

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find 1st Empty Cell in Column D Only If Column B On same Row as Empty Cell, is Not Empty

[SOLVED] Formula to return empty string instead of null when column table is empty

[SOLVED] Using macro to find first empty cell in column. If range is empty returns error.

[SOLVED] Count number of empty columns in a row since non-empty column

Find empty cell in column, and apply required character to empty visable cells.

Need to find empty filled cells in a column and copy to the empty cell below

Copy/Paste to Next Empty Row Overwriting Previous Row When Column A Is Empty

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions