Re: Combine cell info into one cell
- From: Maggie <schmidt.margaret@xxxxxxxxx>
- Date: Tue, 10 Feb 2009 13:03:57 -0800 (PST)
On Feb 10, 3:31 pm, ker_01 <falseaddr...@xxxxxxxxxxxxxxxx> wrote:
Maggie- I believe it is just misplaced parantheses. When I simplify your
formula to make it more readable for troubleshooting by breaking out the
three components of the IF statement, I get:
=IF(
LEN(CONCATENATE(C277))>2,
LEFT(CONCATENATE(C277),LEN(concatenate(C277)-2))
[?]
)
The second statement is trying to subtract 2 from the concatenated string,
instead of the length of that string.
I think you want is:
=IF(
LEN(CONCATENATE(C277))>2, [this part is ok]
LEFT(CONCATENATE(C277),LEN(concatenate(C277))-2), [moved a paranthesis,
added comma]
"" [added null-length string as the third statement]
)
This is aircode, but hopefully that points you in the right direction.
HTH,
Keith
"Maggie" wrote:
Nevermind I figured what was wrong, but now I am getting an error with
the formula to take out the comma and space. I get a #Name? when I
enter the formula. Here is my formula: =IF(LEN(CONCATENATE
(C277,D277,E278,F278,G278,H278))>2, LEFT(CONCATENATE
(C277,D277,E278,F278,G278,H278),LEN(concatenate
(C277,D277,E278,F278,G278,H278)-2)))
My excell will not take the )-2),"") what am I doing wrong?- Hide quoted text -
- Show quoted text -
Thanks it works now, but it still shows the comma and the space. Is
there a way to get rid of the comma?
.
- References:
- Combine cell info into one cell
- From: Maggie
- RE: Combine cell info into one cell
- From: ker_01
- Re: Combine cell info into one cell
- From: Maggie
- Re: Combine cell info into one cell
- From: ker_01
- Combine cell info into one cell
- Prev by Date: Re: convert Week 1 to a date range
- Next by Date: Re: Sum Bold and Visible
- Previous by thread: Re: Combine cell info into one cell
- Next by thread: vba error in sql call command
- Index(es):
Relevant Pages
|
