Search for a number in a column of alpha numeric data and display only the non numeric data

[questforexcel]

Hi All,

So I have a column which has only numbers. For eg. 345678, 674567.

I want these individual numbers to be looked from a series of data which have corresponding Alphanumeric Values eg. 345678 - Computers, 674567 - Printers ...so on.

How do I place a formula which looks up the individual numbers above from alpha numeric values and displays only the non numeric values i.e. the text info.

I assume to ease the reference, the separating symbol is "-" .

I thought of using a vlookup but wouldnt know how would that differentiate the characters to the right of the "-".

Would appreciate all your help.

Thank you

 

[questforexcel]

Okay thank you. Could you help me on how to remove the extra spaces between these alpha numeric values with extra spaces between "-"

Thank you

 

[Fluff]

Probably, but without knowing what exactly you start with & what you want, it's difficult to say.

 

[questforexcel]

Haha...for sure

So if my data reads as "654698 - Copiers - Black & White " and there appear to be extra spaces between the numbers and the "-" and "Copiers" and "Black & White" i'd like my formula to remove these extra spaces.

Thank you

 

[Fluff]

Try
=SUBSTITUTE(A1," - ","-")

 

[questforexcel]

Thank you, it worked. Thats awesome

 

[Fluff]

You're welcome & thanks for the feedback