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

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

Slight tweak, for more consistency in output,
Put instead in C1: =TRIM(A1)&", "&TRIM(B1)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

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

Hayley wrote...
....
But the whole string is in A1

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

If the comma should be just before the second space, try

=REPLACE(A1,FIND(" ",A1,FIND(" ",A1)+1),0,",")

If the comma should be just before the last space, try

=REPLACE(A1,LOOKUP(2,1/(MID(A1,ROW(INDIRECT("1:"
&LEN(A1))),1)=" "),ROW(INDIRECT("1:"&LEN(A1)))),0,",")

If the comma should be before the space to the left of the first
numeral, try the *array* *formula*

=REPLACE(A1,MATCH(TRUE,ISNUMBER(-MID(A1,
ROW(INDIRECT("1:"&LEN(A1))),1)),0)-1,0,",")

My choice would be to do Data TextToColumns with a space delimiter to blow
the string apart into three columns.......then use this formula to
CONCATENATE it back together,

=A1&" "&B1&", "&C1

then Copy PasteSpecial Values......

Vaya con Dios,
Chuck, CABGx3




"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

Thank you that worked great never used this before and you've just saved me
hours of work.

Thanks Again
Hayley

"CLR" wrote:

My choice would be to do Data TextToColumns with a space delimiter to blow
the string apart into three columns.......then use this formula to
CONCATENATE it back together,

=A1&" "&B1&", "&C1

then Copy PasteSpecial Values......

Vaya con Dios,
Chuck, CABGx3




"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