I can't seem to find a formula to add a column of numbers that have text, e.g
50kg+60kg+75kg won't add - can anyone help

Many thanks

Whenever you need to use numbers and text together and also need
computations, use custom formatting:


Pick an empty cell and pull-down:
Format Cells Number Custom and enter General"kg"
if you then enter 100 in that cell, it will appear as 100kg, but you can
still use it for computations.
--
Gary's Student


"Bryan" wrote:

I can't seem to find a formula to add a column of numbers that have text, e.g
50kg+60kg+75kg won't add - can anyone help

Many thanks

Hi Gary - thanks - the problem here is that I am using a weigh scales program
that exports a txt file to excel and I need to sum the total but it is coming
across as xxkg already so when I applied your suggestion it didn't add. I
appreciated your help though. Thanks from Australia!

"Gary''s Student" wrote:

Whenever you need to use numbers and text together and also need
computations, use custom formatting:


Pick an empty cell and pull-down:
Format Cells Number Custom and enter General"kg"
if you then enter 100 in that cell, it will appear as 100kg, but you can
still use it for computations.
--
Gary's Student


"Bryan" wrote:

I can't seem to find a formula to add a column of numbers that have text, e.g
50kg+60kg+75kg won't add - can anyone help

Many thanks

Hi Bryan

Try
=--SUBSTITUTE(A1,"kg","")
this will turn your numbers from text 50kg to 50

Regards

Roger Govier


Bryan wrote:
Hi Gary - thanks - the problem here is that I am using a weigh scales program
that exports a txt file to excel and I need to sum the total but it is coming
across as xxkg already so when I applied your suggestion it didn't add. I
appreciated your help though. Thanks from Australia!

"Gary''s Student" wrote:


Whenever you need to use numbers and text together and also need
computations, use custom formatting:


Pick an empty cell and pull-down:
Format Cells Number Custom and enter General"kg"
if you then enter 100 in that cell, it will appear as 100kg, but you can
still use it for computations.
--
Gary's Student


"Bryan" wrote:


I can't seem to find a formula to add a column of numbers that have text, e.g
50kg+60kg+75kg won't add - can anyone help

Many thanks

Thats it - thanks very much to both of you

Regards Bryan

"Roger Govier" wrote:

Hi Bryan

Try
=--SUBSTITUTE(A1,"kg","")
this will turn your numbers from text 50kg to 50

Regards

Roger Govier


Bryan wrote:
Hi Gary - thanks - the problem here is that I am using a weigh scales program
that exports a txt file to excel and I need to sum the total but it is coming
across as xxkg already so when I applied your suggestion it didn't add. I
appreciated your help though. Thanks from Australia!

"Gary''s Student" wrote:


Whenever you need to use numbers and text together and also need
computations, use custom formatting:


Pick an empty cell and pull-down:
Format Cells Number Custom and enter General"kg"
if you then enter 100 in that cell, it will appear as 100kg, but you can
still use it for computations.
--
Gary's Student


"Bryan" wrote:


I can't seem to find a formula to add a column of numbers that have text, e.g
50kg+60kg+75kg won't add - can anyone help

Many thanks