[saatt79]

Hi,

Say I have multiple data in a spread sheet like,

A
1 DAD111

2 CATUS25

3 58UTIOPS

I want a output like this

Numeric separately and alphabets separately

DAD in one cell and 111 in another cell
CATUS in one cell and 25 in another cell
UTIOPS in one cell and 58 in another cell

Is it possible ?:confused:

[nicespringgirl]

Data->Text and column... follow the instructions you'll get what you want.;)

[saatt79]

Data->Text and column...follow the instructions you'll get what you want.;)

Hi, I know this Text to columns formatting, but if I have some kind of formulaes it would serve me better. Because

For Ex if the data are not in same format like

Dad1233
Ghtathe1589dgk
Adkioejodoejj58964lll

I am not able to split the alphabets and numerics in a separate cells

Thanks

[ScottGem]

Text to columns doesn't really work here. Since you don't have a real pattern that you can match to, this will be very difficult.

You can do it better in Access, because the VAL function will return the numeric portion of a text string. So VAL("123abc") returns 123. So you could build a function that extracts the number, converts it back to a string, then replaces it with nothing in the original string.

[saatt79]

Text to columns doesn't really work here. Since you don't have a real pattern that you can match to, this will be very difficult.

You can do it better in Access, because the VAL function will return the numeric portion of a text string. So VAL("123abc") returns 123. So you could build a function that extracts the number, converts it back to a string, then replaces it with nothing in the original string.

Hi Scott,

Thanks for your reply, but the worst part is I am zero in access and I don't know how to build queries or table in MS Access, but I have some knowledge in MS Excel.

Thanks for your support