Opposite of Concatenation!
 

How do I seperate text and values from within the same cell?

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?

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?

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?