Thankks Max,

But the whole string is in A1

A1 = Woods T 150/1
I need B1 to read Woods T, 150/1


"Max" wrote:

Assuming you have
in A1: Woods T
in B1:150/1

Put in C1: =TRIM(A1&", "&B1)
C1 returns: Woods T, 150/1

Copy C1 down
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Hayley" wrote in message
...
i am trying to use concatenate to i have a cell:
Woods T 150/1

i need it to look like
Woods T, 150/1

can anyone tell me how i do this
Thanks