Easy TEXT Q

[spg2112]

Hello all,

I have a list of text that looks like this:

LAKE AUSTIN SUMMARY 1003
HOUSTON BLDR SUMMARY 1004
VISALIA SUMMARY 1005
ORLANDO BLDR NORTH SUMM 1006
AUSTIN BLDR SUMMARY 1007
COLUMBUS SUMMARY 1008

I want to reverse it and have the number on the right in front of the alpha. I know how to get the =right(A1,4) in a cell, and I was going to use MID to get the text, but i think the MID function goes from left to right. How can I get the left portion of text out of this string?

Thanks guys/gals

Steve

[Barrie Davidson]

On 2002-05-01 19:25, spg2112 wrote:
Hello all,

I have a list of text that looks like this:

LAKE AUSTIN SUMMARY 1003
HOUSTON BLDR SUMMARY 1004
VISALIA SUMMARY 1005
ORLANDO BLDR NORTH SUMM 1006
AUSTIN BLDR SUMMARY 1007
COLUMBUS SUMMARY 1008

I want to reverse it and have the number on the right in front of the alpha. I know how to get the =right(A1,4) in a cell, and I was going to use MID to get the text, but i think the MID function goes from left to right. How can I get the left portion of text out of this string?

Thanks guys/gals

Steve

Steve, try using:

=RIGHT(A1,4)&" "&LEFT(A1,LEN(A1)-5)

Hope this helps you out!

Regards,

[spg2112]

That's it! I forgot about LEN, thanks.

Steve