How to diffrentiate Text & number from a single cell????

P

pack_card2000

:( Hi ther guyz............i a have small problem with the execl
sheets...........
my problem is e.g. i have alot of cells with a number and some text in
it........and they both are in one/single cell (e.g. "878 queen st" in
A1)....now what i want is to remove let's say "queen st" from each cell
so that there is only number left in it.....................i cannot
figure out any formula........if there is any..............need help
imediately
 
D

daddylonglegs

Assuming your data in A1

If the number is always at the beginning and separated by a space from
the rest of the text you could use this formula in another cell

=LEFT(A1,FIND(" ",A1)-1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to diffrentiate Text & number from a single cell???? 2
Concatenate Text, Number and Date 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Emailing from cells 1
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Select cells with text 4
Populate cell with multiple non-blank text values 4
Changing Text To Numbers ? 1

Top