text field

J

johnandbeth

Board Regular

Joined

Apr 8, 2002

Messages

168

• Jun 16, 2006

• #2

Is it always a value of "#,# barg"?

 

Upvote 0

NBVC

Well-known Member

Joined

Aug 31, 2005

Messages

5,828

• Jun 16, 2006

• #3

Try:

=LEFT(A2,FIND("barg",A2)-1)

where A2 contains the string.

 

Upvote 0

Z

zzjasonzz

Well-known Member

Joined

Apr 23, 2006

Messages

649

• Jun 16, 2006

• #4

you can use

Code:

=left(cellnum,3) if it is always #,# as john said

if not you can use

Code:

=mid(cellnum,1,(len(cellnum) - 5)))

both untested but the theory is right

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Jun 16, 2006

• #5

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

 

Upvote 0

R

RF

New Member

Joined

Aug 6, 2004

Messages

21

• Jun 16, 2006

• #6

It is a text field with the value in it
So sometimes 20.8 barg or 1 barg or 0.55 barg.
So I want in the text field that barg can be removed someway.



Thanks,
Roger

 

Upvote 0

NBVC

Well-known Member

Joined

Aug 31, 2005

Messages

5,828

• Jun 16, 2006

• #7

The formula I suggested doesn't care the size of the string before Barg:

=LEFT(A2,FIND("barg",A2)-1)


if you want to convert it to numerical...use

=LEFT(A2,FIND("barg",A2)-1)+0

 

Upvote 0

Aladin Akyurek

MrExcel MVP

Joined

Feb 14, 2002

Messages

85,210

• Jun 16, 2006

• #8

It is a text field with the value in it
So sometimes 20.8 barg or 1 barg or 0.55 barg.
So I want in the text field that barg can be removed someway.



Thanks,
Roger

Click to expand...

=SUBSTITUTE(UPPER(A2),"BARG","")+0

 

Upvote 0