Add a string to a cell

R

ramsdesk

I did below and it worked.

=CONCATENATE("AB",<cell number>)

Thanks for your replies
 
R

RagDyer

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


Regards,

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


I did below and it worked.

=CONCATENATE("AB",<cell number>)

Thanks for your replies.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Function 1
Concatenate cells with line breaks in them 4
Newbie Help - IF Yes No Function 0
complex sort search and replace macro 2
Searching the formula (not the value) for a text string 1
Line Numbers Will Not Show 0
Excel does not accept text format! 0
Conditional format 1

Top