CONCATENATE Help

[rsosebee]

I am attempting to use a CONCATENATE formula to conver Bytes to KB but I am having trouble. I hope someone can help me. Here is my example:

A1 B1 D1
File.txt 6,356,388 6207.41015625 KB

I want it to return as 6,208 KB

Here is my formula:
=CONCATENATE((B1/1024)," ","KB")

Anyone out there offer any advice?

Thank you,
Ryan

 

[BenMiller]

=roundup(b1/1024,0)&" kb"

 

[rsosebee]

AWWW. Thank you!!!!! I appreciate it! Worked Perfectly.

 

[BenMiller]

No problem Glad I could help Appreciate the feedback!