Define name in a cell from contents of another

%3CLINGO-SUB%20id%3D%22lingo-sub-1580950%22%20slang%3D%22en-US%22%3EDefine%20name%20in%20a%20cell%20from%20contents%20of%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1580950%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20speed%20up%20adding%20a%20defining%20a%20name%20in%20say%20F17%20by%20using%20the%20value%20in%20C17%20then%20replicate%20to%20all%20lines%3F%3C%2FP%3E%3CP%3EI%20have%20a%20list%20of%20ingredients%20in%20column%20C%20and%20a%20purchase%20price%20in%20column%20F%20I%20want%20to%20use%20the%20description%20in%20C%20to%20be%20defined%20as%20the%20name%20%26nbsp%3BF%20there%20are%20about%20100%20lines.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1580950%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1581017%22%20slang%3D%22en-US%22%3ERe%3A%20Define%20name%20in%20a%20cell%20from%20contents%20of%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1581017%22%20slang%3D%22en-US%22%3E%3CP%3Ecan%20you%20use%20the%20flash%20fill%20that%20is%20ctrl%2BE%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1581093%22%20slang%3D%22en-US%22%3ERe%3A%20Define%20name%20in%20a%20cell%20from%20contents%20of%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1581093%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F755822%22%20target%3D%22_blank%22%3E%40Vikas_Bhardwaj%3C%2FA%3E%26nbsp%3BThe%20cell%20I%20want%20to%20use%20contains%20Chicken%20Breast%20I%20want%20to%20create%20the%20name%20Chicken_Breast_D%20adding%20_%20to%20all%20the%20spaces%20and%20_D%20at%20the%20end%20as%20I%20already%20have%20a%20name%20Chicken_Breast%3C%2FP%3E%3CP%3Edone%204%20rows%20but%20Flash%20Fill%20can%E2%80%99t%20find%20a%20pattern.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1581211%22%20slang%3D%22en-US%22%3ERe%3A%20Define%20name%20in%20a%20cell%20from%20contents%20of%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1581211%22%20slang%3D%22en-US%22%3Ekindly%20use%20the%20%3DREPLACE(a1%2CFIND(%22%20%22%2Ca1)%2C1%2C%22_%22)%26amp%3B%22_D%22%20where%20is%20a1%20cell%20reference%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1585226%22%20slang%3D%22en-US%22%3ERe%3A%20Define%20name%20in%20a%20cell%20from%20contents%20of%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1585226%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F755822%22%20target%3D%22_blank%22%3E%40Vikas_Bhardwaj%3C%2FA%3E%26nbsp%3BThanks%20for%20that%20do%20I%20have%20to%20replace%20the%20cell%20or%20canI%20link%20it%20with%20flash%20fill%20or%20any%20other%20formula%20to%20put%20the%20Replace%20into%20the%20Name%3F%3C%2FP%3E%3CP%3EKevin%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

can you use the flash fill that is ctrl+E

Highlighted

@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

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

@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