I've tried to combine data from few cells using "CONCATENATE" function. But,
when a cell is blank, a blank appears in the result. How to prevent this
blank?
I've tried to combine data from few cells using "CONCATENATE" function. But,
when a cell is blank, a blank appears in the result. How to prevent this
blank?
please give sample to understand better
"Vicneswari Murugan" wrote:
> I've tried to combine data from few cells using "CONCATENATE" function. But,
> when a cell is blank, a blank appears in the result. How to prevent this
> blank?
=if(a1="","",a1&" ")&if(b1="","",b1&" ")&c1
It kind of sounds like you were separating the cells with space characters.
If A1, B1, C1 all contained words with no spaces:
=TRIM(A1&" "&B1&" "&C1)
Vicneswari Murugan wrote:
>
> I've tried to combine data from few cells using "CONCATENATE" function. But,
> when a cell is blank, a blank appears in the result. How to prevent this
> blank?
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks