F How to extract numbers using RIGHT function in Excel? | CodeTheta

How to extract numbers using RIGHT function in Excel?


RIGHT( ) is a useful function in excel that is used to extract number or text or string from right side of the string or text.

Example -
A
__________________
www.codetheta.com 111
www.codetheta.com 112
www.codetheta.com 113
www.codetheta.com 114
www.codetheta.com 115
www.codetheta.com 116
www.codetheta.com 117
www.codetheta.com 118
www.codetheta.com 119
www.codetheta.com 120
www.codetheta.com 121
www.codetheta.com 122
www.codetheta.com 123
www.codetheta.com 124
www.codetheta.com 125

=RIGHT(A1,3)
We want to extract last 3 digits numbers.

Result is - 

A                                      B
_______________________
www.codetheta.com 111 111
www.codetheta.com 112 112
www.codetheta.com 113 113
www.codetheta.com 114 114
www.codetheta.com 115 115
www.codetheta.com 116 116
www.codetheta.com 117 117
www.codetheta.com 118 118
www.codetheta.com 119 119
www.codetheta.com 120 120
www.codetheta.com 121 121
www.codetheta.com 122 122
www.codetheta.com 123 123
www.codetheta.com 124 124
www.codetheta.com 125 125


If you have any Question you can contact us or mail us.We will reply you as soon as possible.

Post a Comment