View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default 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