Hi all, I have a problem with formating.. in A1 have two words, say "first" and "second" as two lines entered by pressing Alt+Enter after typing the first word. The requirement is remove this formating OR to get these two words separately in single cells. ie B1=First & C1=second ...Any help will be highly appreciated !! Thanks in advance !
Last edited by prasjohn; 12-15-2009 at 02:03 PM.
Data > Text to columns, select Delimited, Next, tick Other and in the adjacent box, press and hold the Alt key, and on the NUMERIC keypad, type 0010, Finish
Entia non sunt multiplicanda sine necessitate
If your data is in A1, B1 can have =LEFT(A1,FIND(CHAR(10),A1)-1) and C1 can have =RIGHT(A1,LEN(A1)-LEN(B1)-1).
You could also remove the breaks altogether by highlighting the column, doing a find/replace, hold ALT and type 0010 (or, if on a laptop, ALT + FN and 0010 on the keypad rather than the row of numbers at the top of the keyboard) and replace with a space or semicolon and then do text to columns with the replacement character as the delimiter.
*Edit: interesting. Didn't know you could just do alternate characters in text to columns like that. Thanks, shg.
That was a real good one.. Thanks a lot !! it worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks