SOLVED

ADDING TEXT TO AN EXCEL PARTS LIST

Copper Contributor

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 changed, as they're not in numerical sequence.

For Example this is what we now have.

P0931
P0939
P0940

We need to find a way (formula) to add these two letters to the beginning of each part of ours (over 1500)

CFP0931
CFP0939
CFP0940
4 Replies

@PROTRIMBOB 

="CF"&A3

You can try this formula.

adding text.JPG

 

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.

 

part number.JPG

best response confirmed by PROTRIMBOB (Copper Contributor)
Solution

@PROTRIMBOB You can use a custom cell format.

"CF"@

Harun24HR_0-1686194597411.png

 

THANK YOU SO MUCH! IT WORKED EASILY!
THANK YOU!
1 best response

Accepted Solutions
best response confirmed by PROTRIMBOB (Copper Contributor)
Solution

@PROTRIMBOB You can use a custom cell format.

"CF"@

Harun24HR_0-1686194597411.png

 

View solution in original post