Forum Discussion
PROTRIMBOB
Jun 07, 2023Copper Contributor
ADDING TEXT TO AN EXCEL PARTS LIST
Anyone know how to add the letters "CF" in front of each part number cell on our Excel part listing? We want to add "CF" in front of our part numbers like these but we don't want the part numbers to ...
- Jun 08, 2023
OliverScheurich
Jun 07, 2023Gold Contributor
="CF"&A3
You can try this formula.
An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
- PROTRIMBOBJun 09, 2023Copper ContributorTHANK YOU!