MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Splitting info in one cell


Posted by RRA on June 27, 2000 12:11 PM

I have some data that comes to me in Excel format. There is one column in particular that includes some data I would like to split out. For example:
1997 Chevy Blazer.

In the above example, I would like to split out the "1997". I would prefer not to use a macro, if anyone knows if a function is available.

Thanks
RRA


Posted by Ryan on June 27, 0100 1:01 PM

RRA,

For the above example this will extract the 1997, and take away any blank spaces infront of it. Let me know if there are any other situations you may need, and how this works.
Ryan

=TRIM(LEFT(A1,FIND(" ",A1,1)))