Character extraction help!

[harami]

Hi

I am familiar with left, right and mid but am unable to get the results below in a streamlined way. I was able to convert the rows using text to columns and then do a concatenation of just the characters and do the right for 3 characters but that is quite painful and not repeatable for large data sets.

Goal: Extract the last three alphabets from each row below.

Data Set: Each row can be of different lengths and is separated per below:

Row 1: ABC ~ XYZ ~ XXX ~ ~
Row 2: ABC ~ GHI ~ ABC ~ EEE ~
Row 3: GHI ~ ABC ~ FFF ~ ~

Desired Output:
Row 1: XXX
Row 2: EEE
Row 3: FFF

Thanks for your help!

 

[cooper645]

Are they separated with just a 'tilde' or 'space tilde space'?

Also, is the sting just in column A and you want the last three alphabet in col B?

 

[harami]

Are they separated with just a 'tilde' or 'space tilde space'?

Also, is the sting just in column A and you want the last three alphabet in col B?

Space and tilde with spaces that arent equal across. $ is spaces in below:

Row 1: ABC$~$$XYZ$~$$XXX$~$~

 

[cooper645]

try the following in B1

=RIGHT(TRIM(SUBSTITUTE(A1,"~"," ")),3)

 

[harami]

Thanks so much! That worked. I forgot that spaces dont count in the trim. Genius!!!!!

 

[cooper645]

Glad to help