dot separated words

[naeemdotcom]

Hi All,
I have dot separated words in column A, eg., apple.orange. Now i want to write each word in separate columns. So apple will go to column B while orange will go to column C.
Can anyone help me do this words separation by some formula?

-----A---------------B-----------------C---
apple.orange ------ apple ----------- orange

How can i get col B and C from col A?

Any help would be highly appreciated.

-naeemdotcom

[hemesh]

assuming your data is in A1, in B1 copy paste below
=TRIM(MID(SUBSTITUTE("."&$A1,".",REPT(" ",100)),COLUMN(A1)*100,100)) and drag to right

or use text to columns options in data tab
select cells you want to separate, click text to columns then click next, in delimiters click others and click box next to it now hold alt key and hit 046 and release alt key.

click next now set destination from B1 hit ok

[naeemdotcom]

Text to Column works just fine
thanks

[hemesh]

you are welcome nadeem ! thanks for the feedback

[hemesh]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.