cell text separation

Replies to This Discussion

Permalink Reply by dan ezuzu on March 30, 2010 at 12:29pm

Hi Irshad,

Your formula is very right, but you do not neccessarily need to put (-1) for it to work. try this:
=LEFT(A1,FIND(" ",A1))

TNX

▶ Reply to This

Permalink Reply by Irshad Aranhikkal on April 9, 2010 at 3:00am

Thanx TNX In fact I drafted it like how I drafted for first name then I realised it wont work. then I changed accordingly. So now you have really made an addition to it. nice , thank you very much

▶ Reply to This

Permalink Reply by Yasir Bilal on April 20, 2010 at 7:52am

well done

▶ Reply to This

Permalink Reply by Sam on February 10, 2010 at 1:28pm

if the last word length is same seperation can be acheived by text to column formula.

▶ Reply to This

Permalink Reply by Diana Vergnano on March 1, 2010 at 6:00pm

select the column and then go into

DATA ==> text in column

1) flag delimit go on
2) flag blank go on

END

hope it's usefull

▶ Reply to This

Permalink Reply by Arun Thomas on March 20, 2010 at 1:18am

Hi Tim,

Selct the rows or coloumn and go to convert to text to coloumns and try, it will work

▶ Reply to This

Permalink Reply by dan ezuzu on March 30, 2010 at 11:28am

HIGHLIGHT CELLS TO BE SEPERATED OR COLUMN WHERE THE DATA ARE
Go to DATA tab
GO TO DATA TOOLS GROUP AND CLICK "text to columns"
CLICK NEXT on the convert Text columns wizard - step
Check "Space" on the delimeters
CLICK NEXT
CLICK FINISH

▶ Reply to This

Permalink Reply by Ivelina Veleva on April 27, 2010 at 10:23am

hi, as the above people have said... go to Data-text to columns-Convert text to columns wizard- delimiters :)

▶ Reply to This

• ‹ Previous
• 1
• 2
• Next ›
• Page