junaid2ali - profile

junaid2ali · Mar 28, 2023

I have a column named MIN and need to add leading zeros when the value in column is less than 4 numbers:BeforeAfter Formula220022456045610000100008888888888999999999999999999This is what I have right now but is giving me an error for the largest numb...

junaid2ali · Mar 06, 2023

I have a column {Sentence with Plain Value}, whenever a value that is listed in column {Plain Value} exists, I want it replaced with the value in column {Value with R Ball} and outputted with other initial values in the sentence. For example:I love t...

junaid2ali · Feb 16, 2023

I have a column 'Original' with the value: Breakfast-NO|Lunch-YES|Dinner-YESI want to the next three columns that are set to formula to automatically be set like this:OriginalBreakfastLunchDinnerBreakfast-NO|Lunch-YES|Dinner-YESFALSETRUETRUE Breakfas...

junaid2ali · Mar 29, 2023

That didn't work for me and am now getting an error message in the column cells, the value is a number, will LEN work with that?

junaid2ali · Mar 07, 2023

Thanks for this, but this solution assumes the R ball is always at the end correct? which is not the case.

User Statistics

User Activity

Add leading zeros to only certain values

Replace a word and output with original sentence value

Extract Values from String in three different places

Re: Add leading zeros to only certain values

Re: Replace a word and output with original sentence value