| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find & replace
Hello
I have datacells with different textdata. Each cell consists of 2 words. I want to cancel the first word in each cell. That first word is not of the same length. How do I proceed? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find & replace
Hi,
To extract the last word =MID(A1,FIND(" ",A1)+1,LEN(A1)) Drag down Mike " wrote: Hello I have datacells with different textdata. Each cell consists of 2 words. I want to cancel the first word in each cell. That first word is not of the same length. How do I proceed? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find & replace
With:
Hello World in cell A1, in B1 enter: =RIGHT(A1,LEN(A1)-FIND(" ",A1)) -- Gary''s Student - gsnu2007k " wrote: Hello I have datacells with different textdata. Each cell consists of 2 words. I want to cancel the first word in each cell. That first word is not of the same length. How do I proceed? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find & replace
=RIGHT(A1,LEN(A1)-FIND(" ",A1))
-- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message ... Hello I have datacells with different textdata. Each cell consists of 2 words. I want to cancel the first word in each cell. That first word is not of the same length. How do I proceed? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find & replace
Maybe you will need to copy/pastespecial values from the helper column
containing formulae given by Mike and Gary"s Student back to the original column. Stefi ezt *rta: Hello I have datacells with different textdata. Each cell consists of 2 words. I want to cancel the first word in each cell. That first word is not of the same length. How do I proceed? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find & replace
=RIGHT(A2,LEN(A2)-FIND(" ",A2))
-- David Biddulph wrote in message ... Hello I have datacells with different textdata. Each cell consists of 2 words. I want to cancel the first word in each cell. That first word is not of the same length. How do I proceed? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find & replace
Hi,
One more, Try DataText to Columns and use space as the delimiter and then delete the first column. You could also go one step further in the Text to Columns wizard and use the Skip column function. HTH Martin wrote in message ... Hello I have datacells with different textdata. Each cell consists of 2 words. I want to cancel the first word in each cell. That first word is not of the same length. How do I proceed? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| find replace cursor default to find box | Excel Discussion (Misc queries) | |||
Linear Mode
