...Concatenate, but more

  • Thread starter Thread starter Hugh Stanley
  • Start date Start date
H

Hugh Stanley

OK, I'm trying to merge a bunch of stuff on a given row into a single
cell on the same row, and want to also insert a keyboard command
...."ALT Enter" into it as well. I'd like some formula like the
following, but ONE THAT WORKS.

Anyone have a clue?


=CONCATENATE(B2," [ALT ENTER] ",C2)

Thanks very much

- Hugh -
 
Try

=CONCATENATE(B2,CHAR(10),C2)

note that you have to format the cells using format>cells>alignment and
check wrap text

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Well, spoke too soon.

The thing did exactly what I wanted, but when I did a cut and "paste
special" / value it reverted back to the [] character instead of the
action ...any way to overcome this when I'm this close?!
 
And you did to the destination cell, what Peo said?

See bottom of mail.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

Hugh Stanley said:
Well, spoke too soon.

The thing did exactly what I wanted, but when I did a cut and "paste
special" / value it reverted back to the [] character instead of the
action ...any way to overcome this when I'm this close?!



Try

=CONCATENATE(B2,CHAR(10),C2)

note that you have to format the cells using format>cells>alignment and
check wrap text
Click to expand...
Click to expand...
 
Couple of things wrong with what you just posted.

#1
I've *never* been able to *CUT* and then "PasteSpecial".
You can *COPY* and "PasteSpecial".

#2
You stated that you tried "PasteSpecial" / "Values".
That action will duplicate *only* the data, and *not* the formats.

Peo advised (warned) you that you needed the "wrap text" format to be set-up
in the cell using the hard line break [Char(10)].
Just format the cells with the visible "", to "Wrap Text", and you should
then properly display what you're looking for.

Going forward, just do a "Copy" - "Paste",
Or a "Cut" - "Paste",
Which will duplicate the data *and* the formats, to properly display your
text.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Well, spoke too soon.

The thing did exactly what I wanted, but when I did a cut and "paste
special" / value it reverted back to the [] character instead of the
action ...any way to overcome this when I'm this close?!
 
It's amazing how much can sink in whilst one hammers out a frustrated
retort to an email where no one understands what I'm saying ...even
when I'm being perfectly clear. ...then it hits me. 'Hey, maybe if I
formatted the place that I'm pasting the information TO after I set up
the formula cell correctly'

...and then it hits me, OK, that's what they were saying when they
wrote ME!

Thanks guys, works great, ...even with my learning curve being as
sloped as my hairy forehead y'all saved me mucho keystrokes!

- Hugh -
 
Back
Top