Ask Your Question

Is there a way to make a formula for information from 3 different cells to show in one cell? [closed]

asked 2017-06-05 13:41:34 +0200

mmoulds1905 gravatar image

I'm making up a spreadsheet to help my credit control team who are not very computer literate so I'm trying to make it as quick and simple as possible for them to complete with as few cells needed to actually be filled in. So I'm wondering can I get information from 3 different cells all showing in one cell. It would be words from one cell, a date from another and then another word from the third eg

C1 - Warrington Branch C2 - 05/06/17 C3 - CASH C4 - Warrington Branch 05/06/17 CASH

I'd like a way to make cell C4 fill itself in once C1-C3 are completed.

Thanks in advance

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-05 23:30:01.762030

1 Answer

Sort by » oldest newest most voted

answered 2017-06-05 14:07:55 +0200

=C1&TEXT(C2," DD/MM/YY ")&C3

Note that I have included the required spaces (to separate values) into the Format argument of TEXT function.

edit flag offensive delete link more


Brilliant - thanks for your help

mmoulds1905 gravatar imagemmoulds1905 ( 2017-06-05 14:37:57 +0200 )edit

Question Tools

1 follower


Asked: 2017-06-05 13:41:34 +0200

Seen: 23 times

Last updated: Jun 05 '17