Define name in a cell from contents of another

Copper Contributor

Is there a way to speed up adding a defining a name in say F17 by using the value in C17 then replicate to all lines?

I have a list of ingredients in column C and a purchase price in column F I want to use the description in C to be defined as the name  F there are about 100 lines.

 

4 Replies

can you use the flash fill that is ctrl+E

@Vikas_Bhardwaj The cell I want to use contains Chicken Breast I want to create the name Chicken_Breast_D adding _ to all the spaces and _D at the end as I already have a name Chicken_Breast

done 4 rows but Flash Fill can’t find a pattern.

Thanks

kindly use the =REPLACE(a1,FIND(" ",a1),1,"_")&"_D" where is a1 cell reference

@Vikas_Bhardwaj Thanks for that do I have to replace the cell or canI link it with flash fill or any other formula to put the Replace into the Name?

Kevin