View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
John Calder John Calder is offline
external usenet poster
 
Posts: 176
Default Concatenate Problem

Thanks for your prompt reply.

Removing the spaces does not make any differencce. I still would end up with
a staggerd text string. What I am aiming for is to have the source text
string aligned to the left and the conctenated text strig to the right

Hope this helps


John


"T. Valko" wrote:

Can't you just remove all the extra spaces from the formula:

....CONCATENATE(I984&" [",B984&" DAYS ]"))

Or, am I missing something?


--
Biff
Microsoft Excel MVP


"John Calder" wrote in message
...
Hi

I use WinXP with Excel 2000

I use a "helper" column in a linked spread sheet with approx 1200 lines of
data that is then used to generate a pivot table.

The formula in the helper colum is as follows:

=IF(VALUE(F984)=0,"",CONCATENATE(I984&" [",B984&" DAYS ]"))

As you can see by the formula that I am adding a reference to another cell
&
the word DAYS inside [] brackets from the text string in cell I984.

This works fine.

However as the original text string is of varying lengths the result is
that
the data that I am concatenating is also staggered.

Example:

BLACK PB4W45855-PN84503-T [ 77 DAYS ]
BROWN PN3W45854-PN43009-T [ 36 DAYS ]
WHITE SPW0363X-PS13007-A [ 77 DAYS ]
E GREEN SPG0463X-PS53008-A [ 77 DAYS ]
RYSDALE BROWN-PN42789-D [ 103 DAYS ]


What I would like to be able to do is have the concatenated data to be
"right aligned" in the cell while the original data stays left aligned.

Example:

BLACK PB4W45855-PN84503-T [ 77 DAYS ]
BROWN PN3W45854-PN43009-T [ 36 DAYS ]
WHITE SPW0363X-PS13007-A [ 77 DAYS ]
E GREEN SPG0463X-PS53008-A [ 77 DAYS ]
RYSDALE BROWN-PN42789-D [ 103 DAYS ]

Is this possible?


Thanks

John