Hi All,
I have a column of part numbers in the format 530020109 but I would like to change to 530 0201 09. Can anyone please advise. Thanks in advance.
Hi All,
I have a column of part numbers in the format 530020109 but I would like to change to 530 0201 09. Can anyone please advise. Thanks in advance.
Hi
custom format (Ctrl+1) as ## #### ##
always that number of characters?
Please make the Post as solved, when you get your answer & Click * if you like my suggestion
hi there. try:
=TEXT(A1,"000 0000 00")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi Guys,
Thanks to all who responded. I tried the first one from Sadath31 and it did the trick. Enjoy the rest of your day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks