RIGHT Function

  • Thread starter Thread starter Doug Van
  • Start date Start date
D

Doug Van

I imported some data that contains a 4 digit number at the end. Not all the
entries are the same width.
I am able to capture the 4 digit number using right(b2,4) and put that into
a new column.
I want to capture the rest of the data minus the 4 digit number.

For example
Metal Goods 5483
Metal Goods - Used 5484

I want to separate columns, I can do the number, but how can I trim the
numbers off.

Metal Goods 5483
Metal Goods - Used 5484

Thanks
Doug
 
Hi Doug
you may try the following:
- in B1 enter the formula
=TRIM(IF(LEN(A1>4,LEFT(A1,LEN(A1)-4),""))
in C1 enter
=RIGHT(A1,4)
or if you need a number use
=--RIGHT(A1,4)

copy both formulas down
 
Hi
sorry. Change
=TRIM(IF(LEN(A1>4,LEFT(A1,LEN(A1)-4),""))

to
=TRIM(IF(LEN(A1>4,LEFT(A1,LEN(A1)-4),"")))
 
Back
Top