how can I Break a raw into two ??

  • Thread starter Thread starter kkraj
  • Start date Start date
K

kkraj

Hi friends
can someone tell me tht how can I convert an Exce
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 :
 
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))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to convert excel file into raw format/file? 2
separating data within a cell - how? 6
How do I read this VBA code? 4
How can I populate table from listbox 3
How to combine two columns into a new column 2
Extract auto-calc % scale so as to construct a macro to addcontrolled Page Breaks 1
HOW I CAN CONVERT NUMERICAL INTO WORDS IN CELL 1
how to remove the page break lines in a spread sheet, 1

Back
Top