add 2 letters to numbers in Excel Solved

Question

Hello,

I would like to add the letters JE in front of numbers that do not follow each other in a column; for example: JE184055 THEN JE185066, I have a total of 8116 different references and I need to add the two letters JE in front of each of these references; I would like to know if there is an automation or if I have to do everything manually;
thank you for your help;

Configuration: Windows XP / Internet Explorer 7.0

Vaucluse · Accepted Answer

Hello
to keep it simple
your column of numbers in A
in B1 the formula:
="JE"&A1
drag it down to the desired height
copy the column and paste it as values in column A
delete column B
best regards

Let’s ask ourselves if we are not the only ones who understand what we are explaining?

ccm81 · Answer

Hello
with a macro it's doable but I don't quite understand the issue
1. does

1235 1236 1237 1255 1256 1263

become

JE 1235 1236 1237 JE 1255 1256 JE 1263

2. we need to know where the data to be processed is located

the simplest thing would be to send a part of your file via cjoint.com with what you expect

good continuation

Mike-31 · Answer

Hello,

Highlight the area to be processed
Right click on the selection/Format Cells/Number tab/Custom

and paste this format to get JE185066

"JE" Standard

if you want the thousand separator JE 185 066

"JE" # ###
--
A+
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.

Add 2 letters to numbers in Excel

3 réponses

Samsung j5 unable to answer

Scam of the suvedene highway

File name too long

No sound with ps3 and hdmi

Wake up from sleep mode in windows 10.

Internet connection problem with my ipad

Free box: remote control broken

Suspicious number text message

I receive calls from unallocated numbers.

Minecraft restore the cursor and the bar.