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 |
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 |