I have a multicolumn spreadsheet with data like record_id=100caller_id=350I need a formula to extract just the number only ie. 100 and 350. I can do text to columns but can only do one column at a time and there are a lot of columns.
If the number is always 3 digits:=RIGHT(A1,3)
If the number of digits could vary=RIGHT(A1,LEN(A1)-FIND("=",A1))
VoG™, thanks the number varies and your second formula works. But I have just noticed I have another type of dataeg.Status_id=normal So is there a formula that would bring me what is to the right of "=" In this case "normal" and the above 100 and 350. Sorry, just noticed after typing the above it also works for text.
This thread is now locked and can not be replied to.
OnePlus 5 review
Alice Saey's mesmerising animation for Dutch singer Mark Lotterman
iPad Pro 10.5in (2017) review
Comment booster votre iPhone ?
© Copyright 2017 IDG UK. All Rights Reserved.