ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Add a string to a cell (https://www.excelbanter.com/excel-worksheet-functions/5193-add-string-cell.html)

ramsdesk

Add a string to a cell
 

I did below and it worked.

=CONCATENATE("AB",<cell number)

Thanks for your replies.


--
ramsdesk
------------------------------------------------------------------------
ramsdesk's Profile: http://www.excelforum.com/member.php...o&userid=15705
View this thread: http://www.excelforum.com/showthread...hreadid=273074


RagDyer

Isn't Frank's suggestion a little shorter and easier?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"ramsdesk" wrote in message
...

I did below and it worked.

=CONCATENATE("AB",<cell number)

Thanks for your replies.


--
ramsdesk
------------------------------------------------------------------------
ramsdesk's Profile:
http://www.excelforum.com/member.php...o&userid=15705
View this thread: http://www.excelforum.com/showthread...hreadid=273074



All times are GMT +1. The time now is 11:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com