Splitting numbers and text to their respective columns

**JEAN1972** · 07-31-2014, 04:04 AM

Hi All

Need help to splitting numbers and text separately to their respective columns

Annexed file for reference

thanks

**XOR LX** · 07-31-2014, 04:13 AM

Hi,

In all your examples the only text to occur in the string is "EA". Is this always the case? If not, can you give further examples to clarify?

Regards

**zbor** · 07-31-2014, 04:13 AM

try this in B3:

Formula:

Please Login or Register  to view this content.

And this in C3:

Formula:

Please Login or Register  to view this content.

**zbor** · 07-31-2014, 04:13 AM

try this in B3:

Formula:

Please Login or Register  to view this content.

And this in C3:

Formula:

Please Login or Register  to view this content.

**JEAN1972** · 07-31-2014, 05:59 AM

Hi

Export sheet to excel all with have EA so i need formula with numbers e.g 12.00 in one column and EA in another column .that is all numbers and text are allocated in their respective columns .

Regards

**JEAN1972** · 07-31-2014, 06:00 AM

Hi

Export sheet to excel all with have EA so i need formula with numbers e.g 12.00 in one column and EA in another column .that is all numbers and text are allocated in their respective columns .

Regards

**JEAN1972** · 07-31-2014, 06:01 AM

Thank you works very well

**Sam Capricci** · 07-31-2014, 06:48 AM

w/o writing a formula, I probably would have done it using find and replace, find "ea" and replace with " ea", then use text to columns and separate at the space - for what it's worth.

Splitting numbers and text to their respective columns

LinkBack

Thread Tools

Rate This Thread

Display

Splitting numbers and text to their respective columns

Re: Splitting numbers and text to their respective columns

Re: Splitting numbers and text to their respective columns

Re: Splitting numbers and text to their respective columns

Re: Splitting numbers and text to their respective columns

Re: Splitting numbers and text to their respective columns

Re: Splitting numbers and text to their respective columns

Re: Splitting numbers and text to their respective columns

Thread Information

Users Browsing this Thread

Similar Threads

Splitting text and numbers from 1 column into separate columns

Any way to import large text file of numbers without Excel splitting numbers?

Help please! Splitting a string of letters and numbers into columns is it possible?

Consolidate text from different Columns in one column with respective heading

Splitting comma delimited numbers into new columns

Bookmarks

Bookmarks

Posting Permissions