Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut last word in cell and paste in next...
Hi, I need to select the last word in a cell for a whole column (B) an paste these words into Column C... I am new to this forum and excel and any tips would be greatl appreciated. : -- KY ----------------------------------------------------------------------- KYO's Profile: http://www.excelforum.com/member.php...fo&userid=1612 View this thread: http://www.excelforum.com/showthread.php?threadid=27562 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut last word in cell and paste in next...
Hi KYO
i'm assuming you have data such as blue cat black dog green mouse and you want to see cat dog mouse in the adjacent column if so, then in cell C1 type =RIGHT(B1,LEN(B1)-SEARCH(" ",B1)) then hold your mouse over the bottom right hand corner of the cell until you see a +, hold the mouse down and drag this formula down column C as far as necessary. then click on the column heading to select all the column and copy it now click on C1 and choose edit / paste special - values click OK and you should have the list you require. Cheers JulieD "KYO" wrote in message ... Hi, I need to select the last word in a cell for a whole column (B) and paste these words into Column C... I am new to this forum and excel and any tips would be greatly appreciated. :) -- KYO ------------------------------------------------------------------------ KYO's Profile: http://www.excelforum.com/member.php...o&userid=16120 View this thread: http://www.excelforum.com/showthread...hreadid=275620 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut last word in cell and paste in next...
Hi
i've just read your post again and then other alternative is to use data / text to columns insert some blank columns to the right of the column you want to split up then select your column choose data / text to columns choose delimited untick tab & tick space click Finish Cheers JulieD "JulieD" wrote in message ... Hi KYO i'm assuming you have data such as blue cat black dog green mouse and you want to see cat dog mouse in the adjacent column if so, then in cell C1 type =RIGHT(B1,LEN(B1)-SEARCH(" ",B1)) then hold your mouse over the bottom right hand corner of the cell until you see a +, hold the mouse down and drag this formula down column C as far as necessary. then click on the column heading to select all the column and copy it now click on C1 and choose edit / paste special - values click OK and you should have the list you require. Cheers JulieD "KYO" wrote in message ... Hi, I need to select the last word in a cell for a whole column (B) and paste these words into Column C... I am new to this forum and excel and any tips would be greatly appreciated. :) -- KYO ------------------------------------------------------------------------ KYO's Profile: http://www.excelforum.com/member.php...o&userid=16120 View this thread: http://www.excelforum.com/showthread...hreadid=275620 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut last word in cell and paste in next...
Try:
Sub xx() ' Or use a function passing in the range as an argument ' i.e. function xx(byval MyRange as range) For Each Cell In Range("A1:A2") CurrentCell = Trim(Cell.Value) Cell.Offset(0, 1) = Mid(CurrentCell, InStrRev(CurrentCell, " ")) Cell.Value = Left(CurrentCell, InStrRev(CurrentCell, " ")) Next End Sub Assumes that words are delimited by a space e.g This Example, This is another example etc. "KYO" wrote: Hi, I need to select the last word in a cell for a whole column (B) and paste these words into Column C... I am new to this forum and excel and any tips would be greatly appreciated. :) -- KYO ------------------------------------------------------------------------ KYO's Profile: http://www.excelforum.com/member.php...o&userid=16120 View this thread: http://www.excelforum.com/showthread...hreadid=275620 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I copy and paste from word to excel, w/o being in one cell | Excel Discussion (Misc queries) | |||
How do I paste a Word document into an Excel cell | Excel Discussion (Misc queries) | |||
Paste from word to excel, into one cell. | Excel Discussion (Misc queries) | |||
How can I paste 429 character Excel cell in MS Word ? | Excel Discussion (Misc queries) | |||
copy a list of items from word and paste in cell | Excel Discussion (Misc queries) |