i want re alter my numbers with special characters

i have many numbers in A column, i want all that numbers in one column with special characters.

is there any way to make like this?

Hello vengatvj,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Regards

Try this:

="CUG "&"("&A2&" / "&A3&" / "&A4&")"

You need more of what?

@ vengatvj and AlKey,

Please take note of the Moderation requests.

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc

Thank you.

Originally Posted by Winon

@ vengatvj and AlKey,

Please take note of the Moderation requests.

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc

Thank you.

Sorry Winon,

I was in the process of replying to OP before you posted your note. Otherwise I would certainly comply with your request.

There were only three numbers in your spreadsheet. You would have to add cells based on the pattern in the formula in order to capture more numbers. Otherwise, I think you may need to look to a VBA solution for your problem.

i have a many details in my excel, many formulas in my excel so that very slow, again i don't want create another one formula.
is there any way to keep formula in any source? its not working while copy and paste from other sheet, i don't know what to do,

i tried in auto-correct options. if i type A* then it replace as my formula., this way also not working , because the base address in my formula not changing, while using this shortcut , friends pls tell me any other solutions

see my excel,

I have looked at your spreadsheet. I don't understand the logic you need to capture the information in Column I and concatenate the information in column AE. In simple language, please explain the logic if you were to do this manually and not in Excel. How do you determine which records from column I should appear in column AE?

You have posted the same question issue in two different threads. I have combined them for the benefit of all forum members. Please do not post the same question in more than one thread. You have been a member of this forum long enough to understand our rules. Please adhere to them in the future.

Hello vengatvj,

To cater for 12 or less Numbers your formula will look like this:

=IF(A13<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" / " &A6&" / " &A7&" / " &A8&" / " &A9&" / " &A10&" / " &A11&" / " &A12&" / " &A13&" ) ",IF(A12<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" / " &A6&" / " &A7&" / " &A8&" / " &A9&" / " &A10&" / " &A11&" / " &A12&" ) ",IF(A11<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" / " &A6&" / " &A7&" / " &A8&" / " &A9&" / " &A10&" / " &A11&" ) ",IF(A10<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" / " &A6&" / " &A7&" / " &A8&" / " &A9&" / " &A10&" ) ",IF(A9<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" / " &A6&" / " &A7&" / " &A8&" / " &A9&" ) ",IF(A8<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" / " &A6&" / " &A7&" / " &A8&" ) ",IF(A7<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" / " &A6&" / " &A7&" ) ",IF(A6<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" / " &A6&" ) ",IF(A5<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" / " &A5&" ) ",IF(A4<>"","CUG"&" ( "&A2&" / "&A3&" / " &A4&" ) ",IF(A3<>"","CUG"&" ( "&A2&" / "&A3&" ) ",IF(A2="","",IF(A2<>"","CUG"&" ( "&A2&" )"," ")))))))))))))

Just make sure that you don't leave empty Rows or Cells, between the numbers.

Also see the attached sample Workbook.

Regards

Hello vengatvj,

You are welcome.

Glad I could help.

You may also Click on the Star to the far left, at the bottom of this Post, to Add Reputation.

Regards

Hello vengatvj,

Thank you for having marked your Thread as Solved, and for adding to my Reputation.