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
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