How to update just part of some text referencing a cell...

[Mattrixdesign]

how do I make a formula so the result is:

BS6724-?C-0010

where the "?" is the number in column "C". I need to maintain the other details.

Thanks

 

[fairwinds]

Re: How to update just part of some text referencing a cell.

Hi,

="BS6724-"&C1&"C-0010"

 

[onlyadrafter]

Re: How to update just part of some text referencing a cell.

Hello,

Do you mean the following

Put this in D23

="BS6724-"&C23&"C-0010"

where C23 is an entered value, or do you want the row number i.e. 23 in this case?

If so, use this formula

="BS6724-"&ROW(C23)&"C-0010"

Are these any use?

 

[Richie(UK)]

Re: How to update just part of some text referencing a cell.

Hi M,

Use either Concatenate or, simply, the ampersand (&):

Book1
	A	B	C	D
1	BS6724-1C-0010		1
2	BS6724-2C-0010		2
3	BS6724-3C-0010		3
4	BS6724-4C-0010		4
5	BS6724-5C-0010		5
6	BS6724-6C-0010		6
7	BS6724-7C-0010		7
8	BS6724-8C-0010		8
9	BS6724-9C-0010		9
10	BS6724-10C-0010		10
Sheet1

HTH

 

[Mattrixdesign]

Re: How to update just part of some text referencing a cell.

Thanks guys!