Convert 3 columns into 1, as text.
 

Hi,
I need to convert 3 columns into 1, as text.

Column C has a direction, North or South, Column D has a route number, 535,
510, 511, and Column E has and arrival time formatted in military time or
h:mm;@ with the results of 8:04, 9:10, 13:04, 14:09.

If row 3, column C, D, and E were to look like;
South, 535, 8:04 or
row 4 were to look like North, 511, 13:04,
I would like to show in column I of row 3, 535S0804 and in
column I of row 4 511N1304.

Any help is appreciated.

Convert 3 columns into 1, as text.
 

=D3&LEFT(C3)&TEXT(E3,"hhmm")
--
David Biddulph

Dale G wrote:
Hi,
I need to convert 3 columns into 1, as text.

Column C has a direction, North or South, Column D has a route
number, 535, 510, 511, and Column E has and arrival time formatted in
military time or h:mm;@ with the results of 8:04, 9:10, 13:04, 14:09.

If row 3, column C, D, and E were to look like;
South, 535, 8:04 or
row 4 were to look like North, 511, 13:04,
I would like to show in column I of row 3, 535S0804 and in
column I of row 4 511N1304.

Any help is appreciated.

Convert 3 columns into 1, as text.
 

in cell I3 type: =D3&LEFT(C3,1)&TEXT(E3,"hhmm") and copy down.
Micky


"Dale G" wrote:

Hi,
I need to convert 3 columns into 1, as text.

Column C has a direction, North or South, Column D has a route number, 535,
510, 511, and Column E has and arrival time formatted in military time or
h:mm;@ with the results of 8:04, 9:10, 13:04, 14:09.

If row 3, column C, D, and E were to look like;
South, 535, 8:04 or
row 4 were to look like North, 511, 13:04,
I would like to show in column I of row 3, 535S0804 and in
column I of row 4 511N1304.

Any help is appreciated.

Convert 3 columns into 1, as text.
 

Micky,
It works excellent, thank you.


"מיכאל (מיקי) אבידן" wrote:

in cell I3 type: =D3&LEFT(C3,1)&TEXT(E3,"hhmm") and copy down.
Micky


"Dale G" wrote:

Hi,
I need to convert 3 columns into 1, as text.

Column C has a direction, North or South, Column D has a route number, 535,
510, 511, and Column E has and arrival time formatted in military time or
h:mm;@ with the results of 8:04, 9:10, 13:04, 14:09.

If row 3, column C, D, and E were to look like;
South, 535, 8:04 or
row 4 were to look like North, 511, 13:04,
I would like to show in column I of row 3, 535S0804 and in
column I of row 4 511N1304.

Any help is appreciated.