Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breakup cells having 2 words with a blank between them
Hi,
Please tell me an appropriate formula which wud give the contents of the cell after the blank. That is if I have "aasd ghyu" , "ert ui", "njiiippi q" in 3 different cells then I wud like a formula which wud give me "ghyu", "ui" and "q" as answers in 3 seperate cells. Please note number of letters in the first word and number of letters in the second word are variable. I dont want to use text to columns as I want to automate this process and use the results in some other formula. Regards, Hari India |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breakup cells having 2 words with a blank between them
If text is in A1, enter the following in another cell:
=RIGHT(A1,LEN(A1)-SEARCH(" ",A1)) This only works if there are two words. Hari wrote: Hi, Please tell me an appropriate formula which wud give the contents of the cell after the blank. That is if I have "aasd ghyu" , "ert ui", "njiiippi q" in 3 different cells then I wud like a formula which wud give me "ghyu", "ui" and "q" as answers in 3 seperate cells. Please note number of letters in the first word and number of letters in the second word are variable. I dont want to use text to columns as I want to automate this process and use the results in some other formula. Regards, Hari India |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breakup cells having 2 words with a blank between them
Hi JW,
Thanx a lot for ur help. Im able to do what I wanted. ( yes there are only 2 words in a cell) Regards, Hari India "JWolf" wrote in message . .. If text is in A1, enter the following in another cell: =RIGHT(A1,LEN(A1)-SEARCH(" ",A1)) This only works if there are two words. Hari wrote: Hi, Please tell me an appropriate formula which wud give the contents of the cell after the blank. That is if I have "aasd ghyu" , "ert ui", "njiiippi q" in 3 different cells then I wud like a formula which wud give me "ghyu", "ui" and "q" as answers in 3 seperate cells. Please note number of letters in the first word and number of letters in the second word are variable. I dont want to use text to columns as I want to automate this process and use the results in some other formula. Regards, Hari India |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Breakup cells having 2 words with a blank between them
On Mon, 7 Jun 2004 22:08:41 +0530, "Hari" wrote:
Hi, Please tell me an appropriate formula which wud give the contents of the cell after the blank. That is if I have "aasd ghyu" , "ert ui", "njiiippi q" in 3 different cells then I wud like a formula which wud give me "ghyu", "ui" and "q" as answers in 3 seperate cells. Please note number of letters in the first word and number of letters in the second word are variable. I dont want to use text to columns as I want to automate this process and use the results in some other formula. Regards, Hari India =MID(A1,FIND(" ",A1),255) --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range Breakup | Excel Discussion (Misc queries) | |||
How to Breakup text in to two parts ina cell | Excel Worksheet Functions | |||
I need to breakup an address in a cell............... | Excel Discussion (Misc queries) | |||
breakup spreadsheets | Excel Programming | |||
breakup spreadsheets | Excel Programming |