copy date & record number seperately in next two columns

[sanyaa]

HI all,

can anyone pl help to solve the issue of split and copy the date and data no in two different columns.Attached a example xls file.

Thanks in advance.

sanyaa

[AlKey]

To get the Date

=TRIM(LEFT(SUBSTITUTE(B2," ",REPT(" ",255)),255))

To get Record No

=TRIM(RIGHT(SUBSTITUTE(B2," ",REPT(" ",255)),255))

[sanyaa]

thanks it worked.

sanyaa

[AlKey]

You're welcome and thank you for your feedback!

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).