add word to the cell in excel

[chuikingman]

If I want change below ouput (column)
1
2
3

into

ABCD1EFGH1IHJK1MNO
ABCD2EFGH2IHJK2MNO
ABCD3EFGH3IHJK3MNO


How can I do that ???

[teylyn]

With

A1 = 1
A2 = 2
A3 = 3

use B1 =
="ABCD"&A1&"EFGH"&A1"&IHJK"&A1&"MNO"

copy down.

Or, if you just want to apply the current row number, use

="ABCD"&row()&"EFGH"&row()"&IHJK"&row()&"MNO"

copy down

[wmfinance]

Here's my answer, starting in column B1. It also assumes that 1 starts in A1:

=IF(A1>0,CONCATENATE("ACBD",A1,"EFGH",A1,"IHJK",A1,"MNO",A1))

copy down

[sandeep.warrier]

Cross post.

http://www.mrexcel.com/forum/showthread.php?t=488057

[arthurbr]

Chuikingman
Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this