LinkBack URL
About LinkBacks
Hi!
I need to concatenate a specific number with another cell, but if the cell is blank, I want the concatenate formula to return blank instead of that specific number. Is this possible?
Any advice on this would help me alot!
Hi!
I need to concatenate a specific number with another cell, but if the cell is blank, I want the concatenate formula to return blank instead of that specific number. Is this possible?
Any advice on this would help me alot!
Last edited by nitrone; 09-29-2011 at 06:58 AM.
A1 cell that can cointan blank
B1 other cell (number)
=IF(A1=""; ""; A1&B1)
Never use Merged Cells in Excel
THANK YOU SO MUCH! It worked!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks