A
A
Alina Shah2020-04-14 03:32:06
Google Sheets
Alina Shah, 2020-04-14 03:32:06

How to display numbers from two cells in one?

The task is probably not easy:
from two cells, write numbers into one, for example, in one cell 38, in another 11, in the third cell you need to see the numbers 3811
and vice versa, from one cell where 57, write 5 into another, write 7 into the third cell

Is such a problem solved?
I use google spreadsheets

Answer the question

In order to leave comments, you need to log in

1 answer(s)
O
Oleg, 2020-04-14
@Shah_Alina

To concatenate, you can simply use "&"(i.e. the formula =A1&B1) , or the "concatenate" formula (=CONCATENATE(A1;B1))
To unlink, use the two formulas, =LEFT, =RIGHT

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question