LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I copy first consonant from a word into new cell

I'm trying to create 2 character alpha codes from whole words. The rules I
need to apply require me to use the first letter from the word followed by
the next consonant. I can seperate the first letter easily but I have no idea
how to capture the following consonant.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to copy the first word or two words from a cell containing a complete sentence to another cell jonny Excel Discussion (Misc queries) 7 May 19th 23 03:43 AM
Copy Word cell containing Shift/Enter to Excel.Keep it as 1 cell Nancy Vazquez Excel Discussion (Misc queries) 0 April 1st 09 07:05 PM
Copy Cell to Word ? Jakobshavn Isbrae Excel Discussion (Misc queries) 0 December 2nd 06 01:00 PM
Help - How to copy word doc contents into a cell phdgrrl New Users to Excel 3 February 18th 06 01:52 AM
Copy Word table into Excel cell by cell hg Excel Discussion (Misc queries) 3 December 15th 04 04:43 PM


All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"