Try this
Sub TTC_SAS()
Columns("A").TextToColumns Destination:=Range("B1"), _
DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1), _
Array(5, 1), Array(30, 1))
Columns("C:D").AutoFit
Columns("D").HorizontalAlignment = xlRight
End SubDon Guillett SalesAid Software dguille...@gmail.com From: Shaik Waheed Sent: Thursday, February 09, 2012 1:44 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ split the value in two part Hi Sanjib, In your sample data u can do this by clicking to 'Data' tab in ur excel sheet--->Text To Colums---> Fixed width-->Next---> Set the scale line as per ur requirement---> finish Do the necessary formatting as per ur requirement. Find the attached sheet for ur review. On Thu, Feb 9, 2012 at 12:49 PM, Sanjib Chatterjee <chatterjee.kolk...@gmail.com> wrote: Dear Sir / Madam, Please see the attached excel sheet. I like to split the name in one cell (i.e. in B) and registration in another cell (i.e in C) Please help me. Thank you in Advance Regards, Sanjib -- - -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
