If it's the same number of characters every time, try Data/Text to
Columns.

You can also do it via formula:

B1: =TRIM(LEFT(A1,FIND("DD",A1)-1))
C1: =TRIM(MID(A1,FIND("DD",A1),255))




In article ,
kkraj wrote:

Hi friends
can someone tell me tht how can I convert an Excel
Raw into two by using Macro ? or any otherway to do tht ? like

CC 123 khi 222 fff 2222 1111 DD 1111 lhr hhh 4444

into

CC 123 khi 222 fff 2222 1111
DD 1111 lhr hhh 4444


Thanks & Regards :)


---
Message posted from http://www.ExcelForum.com/