Home » Forums » Open Source Learning Center » Question and Answer

Splitting letters from words in two different cells

Submitted by cmstirling on 16 October, 2015 - 08:53

Hello,

I have two cells, "2015" and "3Q'15"; I'm wondering if there is a function that I could paste into another cell that would get me "20153" from these two cells i.e. adding the first number of the second cell to the first cell.

I would really appreciate your help, thank you!

C

‹ Macro to take a table with one to many customers with multply invoices and creates flat files per cust with multiple invoices Access VBA code to run excel macro(having code for EssBase retrieve) ›
»

Solution

Submitted by Jon on 17 October, 2015 - 02:27.

Assume:
A1 has 2015
and
B1 has 3Q'15

Now in cell C1 enter this formula:
=A1 & Left(B1,1)

Hope this helps

»

Thank you Jon!

Submitted by cmstirling on 19 October, 2015 - 07:59.

Thanks a lot Jon, saved me. I also found that using CONCATENATE(A1, LEFT(B1)) gets the same result too.

»

.

Submitted by Jon on 17 October, 2015 - 02:31.

.

»