G
Guest
How do I seperate text and values from within the same cell?
G
Guest
Examples of your data would help....Data ==>Text to Columns?
B
Bob Phillips
An example?
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
G
Guest
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
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