Query regarding formatting numbers

[reachkiran03]

I store numbers as 28364269/99800 12790.Like this I have stored 500 to 600 customers.Now my question is how to seperate the number 28364269 from 99800 12790. I want these to appear in different columns, like 28364269 in A Column, & 99800 12790 in Column B. Is there any function or should i do it manually. I don't mind in deleting 28364269 , but for me 99800 12790 is very important.Kiran

 

[Hui]

Kiran

You can either use Text to Columns or a formula to achieve this


1. Goto the Data ribbon , Text to Columns use the space and / as seperators


2. Use a formula

Assuming your data is in A2:A500

In B2 =LEFT(A2,FIND("/",A2)-1)

In C2 =Right(A2, len(A2)-find("/",A2))

 

[reachkiran03]

Thanks a lot Sir I am trying your commands it is working. But I should practice to become perfect. I i get any doubt i will once again draft a mail pls reply Sir. Kiran once again i will thank U for taking your precious time and replying to my mail.