Aug 11 2020 04:54 AM
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.
Aug 11 2020 05:24 AM
can you use the flash fill that is ctrl+E
Aug 11 2020 05:45 AM
@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
Aug 11 2020 06:16 AM
Aug 12 2020 12:42 PM
@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