Ask a new question

Hi, How can I take the first letter of each word in an excel cell , Thanks

Hi, How can I take the first letter of each word in an excel cell , Thanks

|

Please don't repeat the same question! I already deleted one. Are you still seeking an answer that does not require TEXTSPLIT?

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Yes,

I am not traying to repeat my previous question , I gust need to get an answer , and I do not know why my previous question has been deleted ,

Thanks in advance,

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I saw the same question twice, but it seems one was posted in the Insider forum and the other in the Regular Forum. I deleted the one from the regular forum but have now reinstated it. Sorry about that!

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

It is ok ,

Thanks for you reply ,

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

I have got the answer

=CONCATENATE(LEFT(A10,1),"_",MID(A10,FIND(" ",A10)+1,1))

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated May 9, 2024 Views 30 Applies to: