Hi,
My data in one column "Name" looks like this
Travel Eur 02-09 for 128789
Earlier there were only 4 digits at the end and I was using the below expression to get the numbers into another column. Now the number of digits vary, and I need only the numbers in another column. These numbers will be always at the end.
please help me to put the formula to extract the number part from the last irrespective of number of characters.
My data in one column "Name" looks like this
Travel Eur 02-09 for 128789
Earlier there were only 4 digits at the end and I was using the below expression to get the numbers into another column. Now the number of digits vary, and I need only the numbers in another column. These numbers will be always at the end.
Code:
Right(TravelSAP!Name,4)
please help me to put the formula to extract the number part from the last irrespective of number of characters.