advertisement
Forums

The Forum is sponsored by 
 

AAPL stock: Click Here

You are currently viewing the Tips and Deals forum
Google Sheets Help needed!
Posted by: C(-)ris
Date: June 27, 2022 09:43PM
I have a google sheet that has a bunch of serial numbers in the first column, unfortunately, Apple includes a leading S in their barcodes for some unknown reason. I need to go through the list of 500 items and if the serial number starts with an S I need to remove the S.

I know how to remove the first character in a string, but for some of the serial numbers they are in their correctly, there are also S's in the rest of the serial number that I do not remove. So I only want to remove the leading S if it is present. I can't seem to figure out how to do this.



C(-)ris
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Throwback Thursday Signature:
Options:  Reply • Quote
Re: Google Sheets Help needed!
Posted by: gadje
Date: June 27, 2022 09:52PM
=if(left(A1,1)="S", RIGHT(A1,LEN(A1)-1), A1)

EDIT: ALL CAPS to make it easier to read

=IF(LEFT(A1,1)="S", RIGHT(A1,LEN(A1)-1), A1)





Edited 3 time(s). Last edit at 06/27/2022 09:56PM by gadje.
Options:  Reply • Quote
Re: Google Sheets Help needed!
Posted by: C(-)ris
Date: June 27, 2022 10:27PM
Thanks! That worked perfectly.



C(-)ris
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Throwback Thursday Signature:
Options:  Reply • Quote
Re: Google Sheets Help needed!
Posted by: Rolando
Date: June 28, 2022 10:44AM




San Antonio, TX (in the old city)


"All that is required for evil to prevail is for good men to do nothing." - Edmund Burke
“Neutrality helps the oppressor, never the victim. Silence encourages the tormentor, never the tormented." - Eli Weisel

"To announce that there must be no criticism of the President, or that we are to stand by the President, right or wrong, is not only unpatriotic and servile, but is morally treasonable to the American public." - Theodore Roosevelt (1918)

"I don’t want to see religious bigotry in any form. It would disturb me if there was a wedding between the religious fundamentalists and the political right. The hard right has no interest in religion except to manipulate it." - Billy Graham 1981

"Politics and governing demand compromise. But these Christians believe they are acting in the name of God, so they can't and won't compromise" - Barry Goldwater
Options:  Reply • Quote
Re: Google Sheets Help needed!
Posted by: mikebw
Date: June 28, 2022 02:39PM
If the correct serial numbers all have the same number of digits you could also run a formula to truncate everything past that on the start.
Options:  Reply • Quote
Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 61
Record Number of Users: 186 on February 20, 2020
Record Number of Guests: 5122 on October 03, 2020