s would be concatinated without spaces.
Also, the formula is really long.
Regards - Dave.
From: lukethegoo...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Concatenate, including blank fields
Date: Tue, 24 Nov 2009 10:19:37 +
Out of interest what was wrong w
Out of interest what was wrong with Koul's 'concatenate' example with
nested IF's ... ? This is the route I would have gone, although I
would update it slightly like so ...
=CONCATENATE(IF(OR(ISBLANK(A1), A1=" ", A1=" "),"
",A1),IF(OR(ISBLANK(B1), B1=" ", B1=" ")," ",B1),IF(OR(ISBLANK(C1),
.
> Date: Mon, 23 Nov 2009 20:23:33 -0800
> Subject: Re: $$Excel-Macros$$ Concatenate, including blank fields
> From: sca...@aol.com
> To: excel-macros@googlegroups.com
>
>
>
> On Nov 23, 3:22 am, Shujaat Ali wrote:
> > Try this
> >
> > =B4 & " &quo
On Nov 23, 3:22 am, Shujaat Ali wrote:
> Try this
>
> =B4 & " " &C4 & " " & D4
>
> & " " & => will put a space, whether the cells are blank or filled.
>
It's not the same column that's blank each time so you never know
where the space is going to be. I think I found the problem, there's
not a
> you can fill all the balnks with space.
> in order to do the same
> 1. select your range
> 2. press F5,
> 3. then clicke on special button
> 4. select blanks
> 5. press ok.
>
> this will select all the balnk cell in the range. then fill those balnk with
> space (all together by pressing ALTt+Ent
Dear Steve,
you can fill all the balnks with space.
in order to do the same
1. select your range
2. press F5,
3. then clicke on special button
4. select blanks
5. press ok.
this will select all the balnk cell in the range. then fill those balnk with
space (all together by pressing ALTt+Enter) .
attached herewith the solution of your question.
Regards,
Lavprasad
On Mon, Nov 23, 2009 at 2:31 PM, Steve wrote:
>
> I am trying to concatenate 8 columns, all of which containe either a
> single character or a blank. When I use the concatenate funciton it
> leaves out the blank spaces and r
Hi,
The answer is in your questions only. Just put space in blank field.
I hope you got what I am trying to say.
Regards,
Swapnil.
On Mon, Nov 23, 2009 at 2:31 PM, Steve wrote:
>
> I am trying to concatenate 8 columns, all of which containe either a
> single character or a blank. When I use
hi
CONCATENATE(IF(ISBLANK(A1)," ",A1),IF(ISBLANK(B1), " ",B1),IF(ISBLANK(C1), "
",C1),IF(ISBLANK(D1), " ",D1),IF(ISBLANK(E1), " ",E1),IF(ISBLANK(F1), "
",F1),IF(ISBLANK(G1), " ",G1),IF(ISBLANK(H1), " ",H1)
also attached in workbook
On Mon, Nov 23, 2009 at 2:31 PM, Steve wrote:
>
> I am try
HI Steve,
You can insert a blank space ( as long as you want ) in a cell & include that
cell in your concatenate formula every time you need space in between.
The cell will be visible as empty one but it will be having a space in it.
ANURAG SINGH ASWAL
This Communication is Confidential. We
Try this
=B4 & " " &C4 & " " & D4
& " " & => will put a space, whether the cells are blank or filled.
hope it helped.
On Mon, Nov 23, 2009 at 12:01 PM, Steve wrote:
>
> I am trying to concatenate 8 columns, all of which containe either a
> single character or a blank. When I use the con
11 matches
Mail list logo
