hi
i have large data that contain invoice no (in numeric & alphanumeric) and date of invoice in single cell. i want to separate the same in two cell. pl. help me.
hi
i have large data that contain invoice no (in numeric & alphanumeric) and date of invoice in single cell. i want to separate the same in two cell. pl. help me.
Last edited by vinnaik1964; 07-24-2012 at 12:53 PM.
Vinnaik,
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Are the invoice number and date separated by a space, dash or something else unique? If so you can use the text to columns function in the Data tab. Highlight your column before you hit the button and then specify what symbol separates the invoice number and date, then press finish.
JonnyBoy333,
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks