[SOLVED]Formula to MOVE text(actually numbers) from end of cell to new cell

**villdoc** · 03-21-2011, 01:06 PM

Hi I need help with a formula to take a vintage or year at the end of a cell and place in a new cell. I have a spreadsheet of about 1000 wines and need to separate the vintage.
for example:

Malescot-St-Exupery 2009
Pontet Canet 2005
Clos L'Eglise 1999

I know how to remove them I just dont know how to move them

Thanks for your HELP!!!!!

**Ron Coderre** · 03-21-2011, 01:12 PM

With
A1: text ending in a year....eg Pontet Canet 2005

Perhaps something like this....
This formula returns the name
B1: =TRIM(LEFT(A1,LEN(A1)-5))

This formula returns the year
C1: =RIGHT(A1,4)

In the above example
B1 returns: Pontet Canet
C1 returns 2005

Is that something you can work with?

**villdoc** · 03-21-2011, 01:33 PM

Originally Posted by Ron Coderre

With
A1: text ending in a year....eg Pontet Canet 2005

Perhaps something like this....
This formula returns the name
B1: =TRIM(LEFT(A1,LEN(A1)-5))

This formula returns the year
C1: =RIGHT(A1,4)

In the above example
B1 returns: Pontet Canet
C1 returns 2005

Is that something you can work with?

Yes!!! Thanks Ron !!!