jQuery(function($){ if ($(‘#wpadminbar’).length > 0) { $(‘.et_pb_section_0_tb_header’).css(‘top’, ’32px’); } });

remove character google sheets

Remove the Leading Character

I sometimes have a need to extract part of word or text string when using a spreadsheet. For example if I have a hashtag in my spreadsheet #googlesheets and I want to create a clickable hyperlink, the link does not like the hashtag # symbol.


The first formula you might want to use is =len() which counts the number of characters in a cell. For example if you have #googlesheets in cell B1 then using =len(B1) will return 13.


The formula =right() returns the specified number of characters from the right. For example if #googlesheets is in cell B1 then =right(B1,3) returns ets.


Use these 2 formulas together (plus a little of your algebra skills). You want the number of characters minus the first character. So if #googlesheets is in cell B2 then =right(B2, len(B2)-1) will return googlesheets.
google sheets right and length remove a character

Digiprove sealCopyright secured by Digiprove © 2016

Subscribe to the Alice Keeler Newsletter



WP Twitter Auto Publish Powered By : XYZScripts.com