How to copy data from cells without Alt+Enter..
Hi to all,
I want to copy data from a column, in each cell I have entered data which is "Form No." and "Date" with manually entered alt+enter to separate these entries. But now I want separate Data before alt+enter and after alt+enter to copy in two new columns.
I have attached a file to show what I need.
If someone can help I'll be thankful.
BYE.
Hi,
Yes you can.
Highlight the column the data is in (column B in your example)
Select "Text to Columns" from the "Data" menu
Make sure "Delimited" is selected and click "Next"
In the "Delimiters" section, untick everything already selected and tick "Other"
Press and hold the Alt key and type "010" (zero one zero - without the quotes) on the numeric keypad at the right of your keyboard rather than the numbers along the top
When you let go of Alt, the preview pane should show what you're after. Click "Finish" and it's done.
Last edited by Spencer101; 06-24-2012 at 06:19 AM.
If I've been of help, please hit the star
Hello Spencer101,
Thanks for your help. This is what I needed.
Thank you.
To get the Form No you can use this in F2:
Formula:
=LEFT(B2,SEARCH(CHAR(10),B2)-1)
and to get the date you can use this in G2:
Formula:=MID(B2,SEARCH(CHAR(10),B2)+1,255)
Copy the formulae down as far as you need to.
Hope this helps.
Pete
Hi Pete,Originally Posted by Pete_UK
To get the Form No you can use this in F2:
Formula:=LEFT(B2,SEARCH(CHAR(10),B2)-1)
and to get the date you can use this in G2:
Formula:=MID(B2,SEARCH(CHAR(10),B2)+1,255)
Copy the formulae down as far as you need to.
Hope this helps.
Pete
Thanks for your help too. This also works as I need.
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks