| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Opposite of Concatenation!
How do I seperate text and values from within the same cell?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Opposite of Concatenation!
Examples of your data would help....Data ==Text to Columns?
"Chantall" wrote: How do I seperate text and values from within the same cell? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Opposite of Concatenation!
An example?
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Chantall" wrote in message ... How do I seperate text and values from within the same cell? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Opposite of Concatenation!
There are several techniques that might be helpful....but, we need to know
what you're dealing with. Are the numbers at the beginning, end, or middle of the string? Might there be no numbers in some strings? Are the numbers always in the same location of the string (eg 4th character from the left)? Is there a delimiter we can use? (slash( / ), colon (:), word ("Amount: "), etc) You get the idea. *********** Regards, Ron XL2002, WinXP "Chantall" wrote: How do I seperate text and values from within the same cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for opposite of a value in same column | Excel Discussion (Misc queries) | |||
| What is the function opposite of LOG | Excel Worksheet Functions | |||
| Opposite of Concatenate | Excel Worksheet Functions | |||
| opposite of IsNumeric | Excel Discussion (Misc queries) | |||
| Opposite of SUM function is ?? | Excel Discussion (Misc queries) | |||
Linear Mode
