Remove Letters from each of a list of words

[m24jones]

I have a list:
Feb xxxxx
Mar yyyyy
Dec hhhhh

and I want a formula that will remove the first four characters (3 letters and a space) giving me the list:
xxxxx
yyyyy
hhhhh

Is there such a formula? I tried messing around with the UPPER(LEN()) thing but couldn't get it to work.

[Anne Troy]

Why not just:

=right(a1,5)

Where 5 is the number of digits you want to pull. Looks like you've got 5 in each one.

Or, just select the column, and hit Data-Text to columns, and choose space as the delimiter.

[Qroozn]

try
b1=REPLACE(a1,1,4,"")

where a1 is JAN xxxx

_________________
All The Best
Qroozn
If I can do It anyone can
[ This Message was edited by: Qroozn on 2002-05-20 17:01 ]

[Ivan F Moala]

On 2002-05-20 16:57, m24jones wrote:
I have a list:
Feb xxxxx
Mar yyyyy
Dec hhhhh

and I want a formula that will remove the first four characters (3 letters and a space) giving me the list:
xxxxx
yyyyy
hhhhh

Is there such a formula? I tried messing around with the UPPER(LEN()) thing but couldn't get it to work.

Try =MID(D13,LEN(D13)-3,LEN(D13)-4)

Where D13 is the cell that houses the TEXT

[m24jones]

This leaves a space in front of the output - is there a way around that?



[quote]
On 2002-05-20 17:00, Qroozn wrote:
try
b1=REPLACE(a1,1,4,"")

where a1 is JAN xxxx