The store would like to update the Item IDs to remove the letters after the $"$#$".$Fill in the column "Location of #$"$ with the position of the $"$#$"$ in the "Item ID$"$ column. Use the FIND function with the Search Text of an absolute$$reference to cell B$1.$