Wrap text

[Steved]

Hello from Steved

Wrap text

In Col A Surnames Col B first Names

Question using Wrap text in a single Cell.
Is it possible to have Surname on top
the first names below.

 

[Robin Hammond]

Steved,

Set alignment to wrap text on column C and enter this formula
=A2 & CHAR(10) & B2

If that's not what you are after, post back.

Robin Hammond
www.enhanceddatasystems.com

 

[Ragdyer]

A1 = Surname
B1 = First Name
C1 formatted to "Wrap Text"

Enter this in C1:

=A1&CHAR(10)&B1

Without the proper formatting, C1 will display a small square [Char(10)=Hard
Line Break] between the two names.

 

[Steved]

Thankyou RD

-----Original Message-----
A1 = Surname
B1 = First Name
C1 formatted to "Wrap Text"

Enter this in C1:

=A1&CHAR(10)&B1

Without the proper formatting, C1 will display a small square [Char(10)=Hard
Line Break] between the two names.
--
HTH,

RD

---------------------------------------------------------- -----------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------- -----------------

Hello from Steved

Wrap text

In Col A Surnames Col B first Names

Question using Wrap text in a single Cell.
Is it possible to have Surname on top
the first names below.

.