Convert numeric value to text but maintain comma's

[hip2b2]

I think the answer is No Way!!!, but I thought I'd ask anyway.

I would like to copy a 6 digit numeric value in cell "A1" to another cell converting it to a text string and appending a suffix. I am using =A1 &" text" which works except I would like to retain the thousands separators "," The issue does not justify a complex solution, so I suppose anything more complex than a formula is too much.

Thanks as always.

 

[6StringJazzer]

Try

=TEXT(A1,"#,###")&" text"

 

[Rick Rothstein]

Try this...

=TEXT(A1,"000,000")&"Suffix"

 

[jtakw]

Hi,

Another:

Book3.xlsx
	A	B
1	123456	123,456 Text
2	123000	123,000 Text
3	100000	100,000 Text
4	12345	12,345 Text
5	123	123 Text
Sheet888

Cell Formulas
Range	Formula
B1:B5	B1	=TEXT(A1,"#,#")&" Text"

 

[Rick Rothstein]

Here is another possibility...

=REPLACE(A1,4,0,",")&"Suffix"

 

[hip2b2]

Thank you all! Not only was I wrong, but I was very wrong! There were many way to reach the goal posts

Best regards

hip

 

[jtakw]

I'm sure we can come up with more complicated formulas if you'd like.

PS: and @Rick Rothstein can also provide a UDF

 

[hip2b2]

I'm sure we can come up with more complicated formulas if you'd like.

PS: and @Rick Rothstein can also provide a UDF

A UDF would be fun, but completely unnecessary