Very Urgent - Find / Search Help Needed
Hi
Select the cells and goto Data Text to Columns Delemited Next
Delemiters: Check "Other" and enter a dot (.) Next In Data preview the
first column is selected; Column data format: Do not import column. Repeat
for all columns but the last. Change destination if you want to keep
original data. Finish
Hopes this helps
....
Per
"TGV" skrev i meddelelsen
...
I am having the below mentioned data in A1 & A2 cells now i want to extract
the last values from the right side which is lying after the dot (.). The
values i require is "jjjjlkk" & "ajaslfasdld".
abc.2323.zzzzzz.gyhjiol.ksdfsl.6546.jjjjlkk
sdfjas.46465.asdjasdf.dfsjsafl.sdfjslf.sdjsalfasdl .ajaslfasdld
Please suggest me how i can do this...
Thanks in advance.
TGV
|