How to add text before every number in Excel (3 methods) @haminh1804 #msexcel #excelfunctions

Let's learn 3 simple way to add text before every number in Excel:

1. Add the same text for every number
2. Add different text for every number
3. Auto fill down blank cells till next value & then join text + number together

It's so simple, but it'll save you hours of manual work. Let's go!

SKILLSHARE COURSES BY MINH NGUYEN:

Don't forget to like, comment and subscribe if you'd like to see more videos like this one!

Happy learning
Nguyen Thi Ha Minh (Sky Aries)

[JSTX]

Minh thank you so much for getting right to the point and not going into unnecessary nonsense like others on here. THANK YOU!

[ReviewForPreview]

Thanks for saving my 10 minutes everyday.

[stephaniek.]

I have been looking this up and trying to figure out how to do this for 45 minutes. I almost quit then I found your video and I did it within the first minute! Thank you!!! 🥰😁

[CKP]

Thank you for this quick tutorial. I wanted a fast way to attach = before all the numbers. Now I have it.!

[qreZrtb]

Minh, you're amazing thank you soo much.

[Wph-ry]

Very good, very clear instructions. Thank u

[cynhwon]

THANK YOU SO MUCH! I have been looking for this one simple solution which you have explained so well and is EXACTLY what I need to do on a big excel file.

[darshitainternational]

SUPERB>>>THANK YOU >>>YOU HAVE DONE MY WORK

[rsxen]

Thank you! I read how, but seeing it done is much better!

How do I add a letter at the end? For example EN123A or EN123B (letter at the beginning stays the same but just want to be able to add a diff letter as needed at the end.

[commonthoughts]

I have a question for you. Can you help me?

[nparla]

Thank u girl/Madam ☺️ it's very useful ☺️ huge thanks 🥰

[sanikapawar]

I have question
What if numbers are like 301-01 then am I supposed to add alphabet before it
Like I did try to do a you said but it didn't work on this(310-01) types of number
Is there any other way to do it

[SimonCheong-myml]

appreciate your expertise in sharing this, it is really useful. But how do i add the same text (e.g an 'R') infront of all cell in a column that already has text (different text e.g A2 is text C2 A3 is text C3) in them? the end result should be (R C2 and R C3) i assume a formula cannot be use as i want this correction to be in the same cell not adding another column like what you show. TIA

[RubenSen-dxxq]

how to add numbers with existing numbers in excel

[aimighazali]

Hi, what if I want to add a close bracket ")" at the end?. The changing number in the middle. TIA

[UmerKhan-bfpu]

What if we want space between Number And Text?