Add .jpg to Part Numbers in WPS Spreadsheets and Convert Formulas to Values
Question details
The user needs to append the .jpg extension to every part number in a column, fill the formula down automatically, and replace the formulas with permanent text values.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user has a column of part numbers and needs to add .jpg to each item without manually editing every cell.
- Observed behavior
- Part numbers are currently displayed without the .jpg extension; the desired result is a permanent text list ending with .jpg.
Verify that the part numbers are in a single column and that the adjacent column is empty so the formula results can fill without overwriting data.
Append .jpg with a formula and paste as values
Use this method when you need to quickly add the .jpg extension to an entire list and keep static text instead of live formulas.
The formula uses the ampersand operator to join the existing part number with the text ".jpg". When you drag the fill handle, WPS Spreadsheets automatically adjusts the row reference for each row.
Click the cell where the first combined value should appear, such as V3, and enter =U3&".jpg".
Press Enter, then drag the fill handle from the lower-right corner of the selected cell down through all part number rows. WPS updates the row reference automatically.
Select the filled cells, right-click the selection, and choose Copy, or press Ctrl+C.
Right-click the same selection, choose Paste Special > Values, and confirm. The formulas are replaced with permanent text values.
Append .jpg to Part Numbers in WPS Office Spreadsheets
Type a simple formula, drag the fill handle to update all rows, and paste as values to create permanent .jpg part numbers in WPS Office Spreadsheets.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office, open the workbook containing part numbers, and click the cell where the first .jpg result should appear.
- 2. Enter the formula: Type =U3&".jpg" in the first result cell and press Enter.
- 3. Fill down automatically: Drag the fill handle down to apply the formula to all part number rows.
- 4. Convert formulas to values: Select the filled cells, right-click, and choose Paste Special > Values to replace formulas with permanent text.
Frequently Asked Questions
Can I add .jpg to part numbers without editing each cell manually?
Yes. In WPS Spreadsheets, enter =U3&".jpg" in the first cell, press Enter, and drag the fill handle down. Row references update automatically.
How do I stop the combined values from changing if the source part numbers change?
Copy the formula results, right-click the selection, choose Paste Special > Values, and confirm. This replaces the formulas with static text.
Does this method work when part numbers are stored as numbers rather than text?
Yes. The formula converts the value to text and appends .jpg. If part numbers include leading zeros, format the source column as text first so they are not lost.
Can WPS Office save this workbook in Microsoft Excel format?
Yes. WPS Spreadsheets opens and saves .xlsx workbooks, so your part number formulas and pasted values remain compatible with Excel.
