Split the cell Data

**raveepoojari** · 07-14-2010, 12:13 PM

Hi..Everybody,

i have some data in A column.

120 AED
1130 AED
12240 AED
1500 AED
1600 AED
1700 AED
1800 AED
1900 AED
2000 AED
2100 AED
2200 AED
2300 AED
2400 AED
12500 AED
222600 AED
2700 AED
2800 AED
2900 AED
3000 AED

but i need only numberic values in B column and only AED in C coloum

**Marcol** · 07-14-2010, 12:23 PM

Try in B1

=TRIM(LEFT(A1,LEN(A1)-3))

in C1

=RIGHT(A1,3)

Drag/Fill both down

Hope this helps

**raveepoojari** · 07-14-2010, 01:12 PM

Thank You very much

**Marcol** · 07-14-2010, 02:51 PM

Happy to have been of help

Tip
You might want to reconsider your signature message, it conveys, to me at least, a turn of phrase that will not encourage many replies. It's a bit "In yer face."

I'm sure that is not your intention is it?