2 values to one column

[Steved]

Hello from Steved

I have 2 colums column A has numeric and column B has a
single letter.

As an example cell A1 will have 1 and B1 T and in A2 119
B2 T, A3 73 and B3 T. Is there a formula so that in C1
will be 1T and C2 will be 73T and C3 119T.

Thankyou.

 

[Norman Harker]

Hi Steved!

Start trying to work things out; it's easy to just ask but you'll get
more in terms of learning by struggling to get the answer.

Just adding using + won't work! But how else might I join the contents
of cells?

Use the concatenator &.

 

[anonymous]

-----Original Message-----
Hi Steved!

Start trying to work things out; it's easy to just ask but you'll get
more in terms of learning by struggling to get the answer.

Just adding using + won't work! But how else might I join the contents
of cells?

Use the concatenator &.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)


.

Nothing wrong with asking questions but Steved should be a
MVP by now!!!

 

[Norman Harker]

Hi!

It's just a question of trying to work out the answers. No point in
just taking solutions. The efforts of failing to find an answer are
not wasted efforts.

 

[Steved]

Thankyou Norman.

=A1&B1

 

[Norman Harker]

Hi Steved!

Right in one! The point is that your are not adding, which is a maths
operation, but are concatenating. So as another example =12+34 is 46
but =12&34 is 1234