Hi,
I want to add a 0 (zero), if is the case, in specific cell:
i.e in cell A1="XS "&$B1, B1=0235, D1 I want to have XS 0236
I tried D1="XS "&$B1+1 but the result is XS 236
I really appreciate your help.
Thank you.
Hi,
I want to add a 0 (zero), if is the case, in specific cell:
i.e in cell A1="XS "&$B1, B1=0235, D1 I want to have XS 0236
I tried D1="XS "&$B1+1 but the result is XS 236
I really appreciate your help.
Thank you.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
=LEFT(D1,FIND(" ",D1)-1)&" 0"&RIGHT(D1,LEN(D1)-FIND(" ",D1))
Try this in E1 this for a specific case if you are able to provided more data you will get a best solution
Punnam
try
="XS "&TEXT(B1+1,REPT("0",LEN(B1)+1))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Simply:
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Try this...
="XS "&REPT(0,LEN(B1)-LEN(--B1))&(B1+1)
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
="XS"&" 0"&$B1+1 in d1
thank you guys, I really appreciate all your solutions. all of them work.
I can't add rep to Olly and Sixthsense, perhaps the mod will do it for me.
this is solved.
![]()
Hi guys
I need help on copying certain data on filtered cell using excel. I'm able to select using below code
But I use below code it gives error Mismatch, or Range object failed![]()
Please Login or Register to view this content.
Need some solution on this...![]()
Please Login or Register to view this content.
rolta100
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hello Fotis,
Olly and Sixthsense helped me and I can't add rep for them , please do something magic!
cheers
Hi john,
I already received your rep and thanks for the same
May be Olly needs to get it![]()
Greate magic tips!!![]()
![]()
Happy to help, thanks for the rep![]()
Thank you!![]()
your welcome, thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks